By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,327 Members | 1,806 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,327 IT Pros & Developers. It's quick & easy.

Look up

P: n/a
I'm trying to look up an employee ID in a form so it shows on a report.

=Forms!AddAnOrderAndDetails!EmployeeID

I have tried this in a text box in the report without any look:
=Forms!AddAnOrderAndDetails!EmployeeID

Dec 23 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
That should work if:
a) The was open before the report, and remains open (not in design view, not
as a subform.)

b) The form is named AddAnOrderAndDetails.

c) There is a control named EmployeeID.

d) There is a record in the form (even the new record, but not completely
blank.)

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Dave" <da********@hotmail.comwrote in message
news:11**********************@f1g2000cwa.googlegro ups.com...
I'm trying to look up an employee ID in a form so it shows on a report.

=Forms!AddAnOrderAndDetails!EmployeeID

I have tried this in a text box in the report without any look:
=Forms!AddAnOrderAndDetails!EmployeeID

Dec 24 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.