updating information

[Guest]

I have a database that is used by two people. The BE is on the network with
the users both having their own FE on their local drives. The one user has a
form where she enters in information that they call "presale information".
Then the other user has a form that she uses for keeping track of what has
been used out of the "presale information". So her form is set up with a
combo box with a row source that refers to the first users form recordsource
in a query. This way she can't add any new information, she can only choose
what's on the drop down list. The problem I have with the db is that when
the first user enters in information the second user has to close her form
and reopen it in order for the first user's information to be shown in the
list. This is, well, a pain. I was really hoping to somehow get the combo
box to requery without the second user having to close the form or move off
of the record she was on. I have tried doing a save and a form requery, but
this doesn't seem to affect the combo box. Does anyone have any code or
design tips that would be helpful for this situation?

Thanks!

 

[Rick Brandt]

I have a database that is used by two people. The BE is on the
network with the users both having their own FE on their local
drives. The one user has a form where she enters in information that
they call "presale information". Then the other user has a form that
she uses for keeping track of what has been used out of the "presale
information". So her form is set up with a combo box with a row
source that refers to the first users form recordsource in a query.
This way she can't add any new information, she can only choose
what's on the drop down list. The problem I have with the db is that
when the first user enters in information the second user has to
close her form and reopen it in order for the first user's
information to be shown in the list. This is, well, a pain. I was
really hoping to somehow get the combo box to requery without the
second user having to close the form or move off of the record she
was on. I have tried doing a save and a form requery, but this
doesn't seem to affect the combo box. Does anyone have any code or
design tips that would be helpful for this situation?

Thanks!

You need to Requery the ComboBox itslef. In a form procedure...

Me!ComboBoxName.Requery

 

[Guest]

Ok, so just to make sure I understand. In the first user's form on the after
update of a field where she enters in this information, I can put the code
you suggested and it will requery the other form's combo box, even though she
has the form open and in use?? Obviously I know I need to have the code say
the name of the other form and the name of the combo box, but am I
understanding you correctly otherwise?

at

 

[Guest]

It says it can't find the form. I suppose because technically the second
users form isn't open on the first users computer. Any other ideas?

 

[Rick Brandt]

It says it can't find the form. I suppose because technically the
second users form isn't open on the first users computer. Any other
ideas?

The second user is the only one that can issue the Requery. You could run it in
the GotFocus event of the CombobBox so that every time it is used it is
requeried.

 

[Guest]

Well that makes sense - to do it on the second users form. Sometimes, I make
things way too hard! That worked great, thanks so much!

at