sim-Requery in an unbound tabbed form

[bgv]

I have a tabbed form with four forms attached; Employees, Station Manifest, Daily Roster, and Activities. The Daily Roster form is unbound but are populated currently from a query. All but one of the fields on the Daily Roster form are locked, since they are read from the table query.

I have run into a problem. When I change the number of records on the Station Manifest form, I want the changes to be immediately reflected when I select the Daily Roster form tab. This does not happen unless I close the form and manually reopen it again.

If the Daily Roster form was bound, I could perform a requery and the response would be immediate. What can I do to make this Daily Roster form show the changes immediately?

 

[KenReay]

Hi

Without knowing exactly how you are populating thios unbound form I would say:

rerun the query which is used to source its data

re-execute the routine which populates its controls

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[bgv]

Tried that already. I think the problem lies in the fact that by clicking from one tab to another, the records in the previous tab are not saved to the database table and when the second tab is opened the records it seea have not been refreshed.

How would you save the records in a tabbed form to the database so the other sub-forms in the tabbed form can pick them up when the click event occurs?

 

[KenReay]

Hi

I do not follow what you are saying

The forms are presumably bound forms?

On a continuous or datasheet view, (bound form) data is save as soon as you move off the record

Are you saying all of the tabs are looking at the same data?, seems a little odd ?



Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK