Automatic fill in (1 Viewer)

krieb

New member
Local time
Today, 22:40
Joined
Jan 22, 2000
Messages
9
I have one table called Primers, whose primary key is PrimerName. I have designed to forms, FormA =PrimerF1 and FormB =SUMMARY. The user inputs information into formA creating records for each primer. The SUMMARY form has a list box with a field referred to as Primer 1 Name. Once the user selects a primer, I would like selected information (sequence, Alias primer name, and location) to show up based upon the primer name selected.
 

Travis

Registered User.
Local time
Today, 15:40
Joined
Dec 17, 1999
Messages
1,332
Make the RowSource of the Summary List box something similar to this:
"Select sequence, Alias primer name, location from [YourTable] where PrimerName = Forms![FormA].[PrimerName]"

Using the Form Location is the important part here.

Next on the AfterUpdate of the PrimerName Field add this:

Forms![FormB].[SummaryListBox].Requery

This will requery the listbox and include the new data.
 

Users who are viewing this thread

Top Bottom