copy query by option

[maryanne]

hi all,

i have combo box which has two value list (resale
price,margin).what i wanna do is after i choose either one
of them, it will copy certain query to my final query. so
the sequence would be like this:

if user choose 'resale price', whole record in query A
will be copied to query final
if user choose 'margin', whole record in query B will be
copied to query final.

please help me for its vba code.

thanks

 

[Michel Walsh]

Hi,

In the procedure that matches a change of the combo box value (
AfterUpdate, of the control, not of the form), issue the "required query or
SQL statement, or VBA code". You original description of the problem, "whole
record to be copied" is not informative enough to hint us, at least, me,
about the final result you want.


Hoping it may help,
Vanderghast, Access MVP