Form ID selection comes up in other form

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

Guest

If I select a record in a form, let's say on a list box, I want another form
to popup with that same record (referencing to ID). I want the second form
to open up and view that record by ID. These forms each have referential
integrity, but for designing reasons I don't want to create a subform within
the original form. Anyway I can do this?
 
Assuming the listbox on the first form is named List0, and you want to
open form Form1, in whose recordsource you want Field1 to match the
value selected in List0:

DoCmd.OpenForm "Form1",,,"Field1 = '" & Me.List0 & "'"

if Field1 is text, or:

DoCmd.OpenForm "Form1",,,"Field1 = " & Me.List0

if Field1 is numeric.

HTH,
Nikos
 
You must log in or register to reply here.

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

How to Retrieve data from Main form & subform based on ID field? 2
Main Form with Subforms 5
Need help on how to pass calculated field from a form to another form 0
Need help to Simplify a Complex Calculation on a Form 0
Click a subform field to open relevant form 5
Validation in child form 1
Go to specific record on form 4
filtering a form based on the values of a subform 0

Back
Top