Getting #Name? in Text box

  • Thread starter Thread starter pellis1
  • Start date Start date
P

pellis1

I added a label box in the canned ORDERS1 db Order Entry
Form named Patient ID. I added a text box beside it and
gave it the Control Source of Patient ID. 2 problems:
1- IT WILL NOT LET ME ENTER THE VALUE I WANT IN THE TEXT
BOX, WHAT APPEARS IS: #Name?
2- How do I 'link' the two boxes?

NOte: I am not a programmer type...THANKS IN ADVANCE FOR
HELP!
 
You say you inserted a label and a textbox and gave both items the name
Patient ID? If so, you have a conflict, each item needs its own name. Is the
Patient ID field that you put in the control source of the text box a field
in the form's Record Source? Why did you add a separate label instead of
just using the one that would have been made when you inserted the text box?
 
I wanted a field in the existing form. I wanted it to
look like the other fields in the form. For example, the
one of the other field labels is Phone Number and you
(the user) enters the number in the blank next to it. So
I went into Design View and saw that the PHONE NUMBER box
is named Phone Number_Label and box you enter in is named
Phone Number with a Control Source of Phone Number. So I
made the properties of my 2 new boxes the same way. Are
you saying that if I delete the text box, that the label
box I created will make it's own text box?
Thanks
 
I wanted a field in the existing form. I wanted it to
look like the other fields in the form. For example, the
one of the other field labels is Phone Number and you
(the user) enters the number in the blank next to it. So
I went into Design View and saw that the PHONE NUMBER box
is named Phone Number_Label and box you enter in is named
Phone Number with a Control Source of Phone Number. So I
made the properties of my 2 new boxes the same way. Are
you saying that if I delete the text box, that the label
box I created will make it's own text box?
Thanks
Click to expand...

Actually, it's the other way around.
The Access default is to include the label with the text control.

However, if this is a bound control...

If the table is the Recordsource for the form, click on the Field List
tool button and drag the new field onto the form. It will have the
label attached.
If a Query is the form's recordsource and this is a new field added to
the table, first add the new field to the query, then use the Field
List to drag it onto the form. The label will be attached.

No matter how you do it, the Label and the Text Control MUST have
different names.
 
Back
Top