multi table query to create new records

[crobaseball]

I have a multi table query which is built for a form. It looks like this:





As you can see, I'm looking to have user input narrow down a particular Supplier and Series. My problem comes into play when I go to enter a new record. I want the record to autopopulate with the [SeriesID] and display the SupplierName when a new record is entered. So the form looks like this:



And I want the SeriesConnectedTo to show 1, with the supplier and SupplierName displaying when the series number is input as a parameter. Thoughts?

[crobaseball]

I didn't explain this very well. Let's make it more generic: basically I want the parameters to pull up the Supplier/Series information to confirm to the person inputting the data that they have the correct Series they are updating. Then I want to be able to create new records for the correct series.

[June7]

Maybe use a multi-column combobox for the SeriesConnectedTo input.

[crobaseball]

Can I do this for a new record?

[crobaseball]

Just as importantly, the number of records to scroll through on the combobox will be rather large. Just a shade over 300. Is there a way to input the number to have the combobox pull the right value?

[June7]

300 records is not an unmanageable length for combobox. Can type in combobox and AutoExpand feature will match entries. Can also use code to force the dropdown list to show so as user types they see the available matches in the list.

[crobaseball]

Got it! Thanks!

[crobaseball]

This worked great btw . . .