copy query by option

  • Thread starter Thread starter maryanne
  • Start date Start date
M

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
 
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
 
Back
Top