Multi-user database (5 users max)
5 tables
tblProject (main table, projectID is primary key field)
tblCustomer (CustomerID is Primary, projectID is foregn)tblPrincipal (PrincipalID is Primary, projectID is foregn)
tblPart (PartID is Primary, projectID is foregn)
tblNote (NoteID is Primary, projectID is foregn)
I have relationships established.
There is a single screen form
Mainform
It has a tab control with subforms for each tab to each table.
When one user adds a new record, locks it, edits it and releases it.
A second user goes to add a new record. I do the following to update the 2nd users recordset so she is aware of the first users added record prior to adding another record.
forms![mainform].setfocus
me.requery
The me.requery should show the fact the the number of records in the table has increased by one but it does not.
I have tried everything I know to correct this. I even created a button on the mainform that calls a function that does "Me.requery". That works but it will not work within the routine called from another button on the same form.
Please advise ASAP.
I am going crazy. :-(
rfreema1@ameritech.net or
rfreema2@ameritech.net
Thanks!
5 tables
tblProject (main table, projectID is primary key field)
tblCustomer (CustomerID is Primary, projectID is foregn)tblPrincipal (PrincipalID is Primary, projectID is foregn)
tblPart (PartID is Primary, projectID is foregn)
tblNote (NoteID is Primary, projectID is foregn)
I have relationships established.
There is a single screen form
Mainform
It has a tab control with subforms for each tab to each table.
When one user adds a new record, locks it, edits it and releases it.
A second user goes to add a new record. I do the following to update the 2nd users recordset so she is aware of the first users added record prior to adding another record.
forms![mainform].setfocus
me.requery
The me.requery should show the fact the the number of records in the table has increased by one but it does not.
I have tried everything I know to correct this. I even created a button on the mainform that calls a function that does "Me.requery". That works but it will not work within the routine called from another button on the same form.
Please advise ASAP.
I am going crazy. :-(
rfreema1@ameritech.net or
rfreema2@ameritech.net
Thanks!