Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Forms Linking what am i doing wrong

Status
Not open for further replies.

jeremy0028

Technical User
Oct 9, 2005
37
0
0
US

I have a main form called IRI-Form

On that form i have

PersonID(AutoNumberPK)Last Name First Name Middle Name

I have a command button called Add Charge which open a pop up form called frmAddCharges

In the frmaddcharges I have a text box called Patient
In the control source i have the following

=Forms!IRI-Form!FirstName & " " & Forms!IRI-Form!LastName

So when a user clicks add charge it will relate to the same patient

I get the following error #Name? in the text box any ideas.
 
Try =Forms!IRI-Form.FirstName & " " & Forms!IRI-Form.LastName

Appologies if I'm wrong. Been off Access a while
 
. . . or perhaps:
Code:
[blue]   =Forms![IRI-Form]!FirstName & " " & Forms![IRI-Form]!LastName[/blue]

Calvin.gif
See Ya! . . . . . .
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top