Help with this Form? Please!

G

Guest

I have a form which shows records in datasheet view, when I select any record
by double clicking on it I have another form opening showing only the record
I selected. I did this by creating a query for my second form with a pointer
(in the criteria) to the field in the main form which matches with one of the
fields in my second form. This works fine whenever I am in the main form but
I have embedded the main form and now when I double click on a recorded I get
the following prompt: Enter Parameter value… Could someone kindly advise me
as to how to get rid of this prompt?
 
S

SusanV

Since it is now a subform, you must reference the parent, then the subform,
then the control:

Forms!Parentform.SubformName.Form!ControlName
 

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

Query Parameter using multiple options 0
Open form for record selected in subform 2
keep focus on a subform record 1
A little form to search main from 3
Problem with form--subform 5
Forms PLEASE HELP 9
How to get value of column from subform 2
Access Open Form with WhereCondition 6

Top