changes in Table Design don't take in Form View

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I make a change to a field in Table Design (for example, create a drop down
box where there was none). I then close that window, open Forms View to
enter data, and the change to that field has not taken place. What am I
doing wrong?
 
Rich said:
I make a change to a field in Table Design (for example, create a
drop down box where there was none). I then close that window, open
Forms View to enter data, and the change to that field has not taken
place. What am I doing wrong?

Expecting that to happen. The only design aspect of the form that cares one bit
about the design of the table is the presence or absence of fields and their
DataTypes.

Most of the "inheritance" from tables that you see in forms is provided by the
form wizards when the form is first created. After this most changes have to be
done in both places separately.
 
You have to refresh the field in your form. This can be accomplished
one of two ways: 1) in your form, delete the field and reinsert it; or
2) go into the field's properties, change the Control Source to a
different field and click out of it, then change the field back to the
original field, which refreshes the field.

I hope this helps!
 
You have to refresh the field in your form. This can be accomplished
one of two ways: 1) in your form, delete the field and reinsert it; or
2) go into the field's properties, change the Control Source to a
different field and click out of it, then change the field back to the
original field, which refreshes the field.

I hope this helps!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top