form data based on criteria entered in another form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I have a form that has an 'on open' event that starts a macro that opens
another form that lists account numbers, I choose an account number and click
my 'ok' button which sets the value of a criteria for a query whose results
show in the original form.

unfortunately when I open the form it asks me to enter a parameter value
instead of letting me choose the parameter value from the account list.

I did the same thing only with a report - ie a report that has an 'on open'
event that starts a macro that opens a form that lists clients last names of
which I choose one and click 'ok' which sets the value of a criteria for a
query whose results show in the report - this works fine but I can't seem to
make the same idea work for a form.

Why might this be? sorry if I haven't provided enough information.

TDR
 
suggest you open the "criteria" form first, choose the account number, then
open the form which is based on the parameter query.

hth
 
Back
Top