Update Form

[Raven]

I always find that if I update a field in a table, I have to then re-insert the field on the form it sits on in order for the changes to be pulled through.

Does anyone know of a kinda 'refresh' that I can do which will save me the time of having to re-insert fields on the form?

Thanks

 

[Robert Dunstan]

Hi,

Are you changing the table structure i.e. field name etc?

If so then I'm not aware of a quick refresh method to update your other objects in the database. The best advice I can give is not to change the existing structure unless it's absolutely necessary

 

[Raven]

I am changing various information, for instance I have a lookup field in which I require to add additional choices.

After adding these in the table, I have to re-insert the field on the form. I'm just looking for a quick refresh trick in order to avoid this.

 

[Robert Dunstan]

Ah right ok...


What I tend to do is create a seperate lookup table to contain information. This table is not linked to anything else.

For example I have a PayGrade table which contains about a dozen records of the different grades of pay i.e. manager, project manager etc. Then in my main Employee table I have a text box called PayGrade. Now in my form for Create New/Amend Existing employee records, I have combo box which is bound to the PayGrade field in tblEmployee but has a query in its rowsource which querys the lookup table. This means if I add new PayGrade to the lookup table, it is then picked up in my form as well.

HTH
Rob

 

[Raven]

Thanks for this, I have used a look up for a more complex example of this, but the lookup in question only contains 5 items so I didn't think it would warrant a table of it's own.