Carol Murphy
Thread Starter
- Joined
- Feb 25, 2000
- Messages
- 17
Hi,
Can you pass criteria data to a query in code?
I have 2 forms. In the main form, I enter student SREG and the linked form then automatically shows the associated ADDRESS (if one exists). I then want to run a query which will Append this address record to a separate LOANContactDetails table.
I can do this but the query asks for [SREG] to be entered (as set out in the criteria). It's frustrating because I have this value already (can display it throgh msgbox(Me!Sreg) ) Can this value be passed to the query through the code so the the user does not need to enter this again?
Any help would be much appreciated.
Carol
Can you pass criteria data to a query in code?
I have 2 forms. In the main form, I enter student SREG and the linked form then automatically shows the associated ADDRESS (if one exists). I then want to run a query which will Append this address record to a separate LOANContactDetails table.
I can do this but the query asks for [SREG] to be entered (as set out in the criteria). It's frustrating because I have this value already (can display it throgh msgbox(Me!Sreg) ) Can this value be passed to the query through the code so the the user does not need to enter this again?
Any help would be much appreciated.
Carol