If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#31
|
|||
|
|||
Hi Steve :-)
Jan, Is frmCheckRegister open at the time? You might need a line like this at the beginning of the procedure... DoCmd.OpenForm "frmCheckRegister" Blue Eagle 1, this is Blue Eagle 2, we have now neutralized the 'Bugger... YES!! ;o)) And, what's the difference between a gizmo and a wazoolie? Oh.....w'll....a gizmo is a thing....and.... a wazoolie is....eh... everything. See...? Thank you very much for all your time and help, and patience. I really do appreciate it. :-) Jan Smiles are meant to be shared, that's why they're so contagious. Jan Il wrote: Hi Steve :-) No..sorry, that did get in there twice, a carry over I missed I guess. I have removed the one in the first line, and now have this code. I got the whole wazoolie this time. :-) Private Sub fmeOptionGrp_AfterUpdate() With Forms!frmCheckRegister Select Case Me.fmeOptionGrp Case 1 .RecordSource = "SELECT * FROM qryCkRegisterDan WHERE CheckNo Not Like 'DBT*'" Case 2 .RecordSource = "SELECT * FROM qryCkRegisterDan WHERE CheckNo Like 'DBT*'" Case 3 .RecordSource = "qryCkRegisterDan" End Select End With End Sub But, the debugger is still barking at the line: With Forms!frmCheckRegister Clicking on the buttons is now firing a Runtime error 2450, and the message "Microsoft Access can't find the form 'frmCheckRegister' referred to in a Macro expression or Visual Basic code. But, frmCheckRegister *is* the name of the Record Form to be opened and the data is to be displayed. I'm not sure I understand what is causing this error message. Thank you. Jan |
#32
|
|||
|
|||
Roger, 2. Very nice,
-- Steve Schapel, Microsoft Access MVP Jan Il wrote: Hi Steve :-) Blue Eagle 1, this is Blue Eagle 2, we have now neutralized the 'Bugger... YES!! ;o)) |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Still Hoping for help with a Query problem | Don Sealer | Using Forms | 15 | November 13th, 2004 06:24 AM |
Union Query Not Returning A Value | Jeff G | Running & Setting Up Queries | 2 | October 19th, 2004 05:47 PM |
query a number stored as text | Lee | Running & Setting Up Queries | 19 | October 13th, 2004 04:10 AM |
Using Start Date and End Date in Query | ChuckW | Running & Setting Up Queries | 5 | July 20th, 2004 02:52 AM |
I can see the data but... | David F-B | General Discussion | 3 | June 24th, 2004 06:15 AM |