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

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
 
G

George Nicholson

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,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop down lists in seperate columns 5
Drop down list control value in vba 2
How can I give customized drop down in Ms Forms online or refer dropdown from excel list 0
list or combo box 0
Creating a template for a standing order from a client 2
drop down list 1
as field is selected from combo drop down eliminate it from the li 12
Drop Down List 1

Top