Autofilling a subform from a drop down list. Second request.

  • Thread starter Thread starter Michael
  • Start date Start date
M

Michael

I have an orders database and I need to have standing orders for some
clients.
I want to put a dropdown list on the order form with a list of clients with
standing orders.
When the user chooses a client in this list the order form and the subform
is completed except for the amount of pallets.

I don't understand how to make a query that takes the information from the
standing orders table and feeds them into the sub form on the current page.
thank you for your help
Michael
 
I don't think a query by itself will do it.

in code:
- Open a recordset (query) with your standing order data for the selected
client
- Copy the recordset data into your form, field-by-field
- Return control to user so # of pallets can be entered

You *might* be able to construct an append query that appends a record from
StandingOrders to your form recordsource and then requery the form, but that
assumes a lot of things: all "required" fields being supplied by
StandingOrders data, etc. Potentially impossible, at best very messy.

HTH,
 
Back
Top