I need to place fields on a form that is not linked to a table or query. Form was built by my predecessor and it already contains multiple fields, however the form itself is not linked to any data source. I have tried hardcoding the field onto the form, but it didn' take. How is this done?
Placing fields on a form
- Thread starter mdwilcher
- Start date
statsman
Active member
- Local time
- Yesterday, 22:58
- Joined
- Aug 22, 2004
- Messages
- 2,082
With the field in design view, right click the field. Select properties.
Under "Control Source", select the field you want the text box linked to. It's a good idea to give the Text Box name the same name as the field name.
It sounds to me as though your predecessor may have gone about entering data another way.
Again, with the form in design view, right click a text box. This time select "Build Event" and then "Code Builder".
If you see coding such as:
[whatever] = [whoever]
anywhere in the code, your predecessor used a different method of entering data and you have got problems.
Under "Control Source", select the field you want the text box linked to. It's a good idea to give the Text Box name the same name as the field name.
It sounds to me as though your predecessor may have gone about entering data another way.
Again, with the form in design view, right click a text box. This time select "Build Event" and then "Code Builder".
If you see coding such as:
[whatever] = [whoever]
anywhere in the code, your predecessor used a different method of entering data and you have got problems.
