Adding a text box to a form

[punter]

Hi,

I'm having a little problem with one of my forms. I have a table called

BOL_Entry

and I just added a new field in there named

Carrier

. I want to add a text box onto a form called BOL_Entry for the

Carrier

field. When I got to the drop down choices for that text box

Carrier

is not an option. When I try to build it using the expression builder I'm getting

#Name

in the text box.

Any thoughts on what I'm doing wrong? This has to be easy.

Thanks

Eddie.

 

[boblarson]

If your form is based on a query (which they should be) you have to remember to add that field to the query first, before it becomes available to the form.

 

[rainman89]

is the form bound to the table? if so you should be able to see carrier in the field list

 

[punter]

Stupid (punching myself in the head), that is right Bob. You told me to set it up like that months ago. I took your advice but it was working so well I forgot that is how I changed it.

Thanks for the quick replies. I got it now.

Eddie.