openform filter problem

R

Raymond Chiu

DEar all,

docmd.openform "forms1", , , field1=forms.forms2!field1

THe form forms1 display without showing records.

What is the problems?


Thanks,

Raymond
 
R

Raymond Chiu

Dear raymond

it should be

docmd.openform "forms1", , , "field1='" & forms.forms2!field1 & "'"
 

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

Filter by form - empty drop down list 3
Possible to link fields in a form to narrow selections? 4
Split form 0
Cannot open a form using "Docmd Openform" 1
Filter 7
Checking records 1
updated field 5
Image control source linked to text box as descibed by Allen Brown 5

Top