update List Box without closing and opening ms access

[zxmax]

Greeting,
- i have a form, that has a List Box coming from a table ,,
This list box when you click on it, it shows that field in the main form
- and i have a front end and a backend to this database,
- When i add a new entry in my main form, it shows in the List Box just fine, but when i click on that list box, it doesn't show the entry on anyone else on the network - works ok locally

here is an eg: my main table has firstName, LastName, PhoneNumber, Address

Form : main form has firstName, LastName, PhoneNumber, Address
List Box inside my Form has: First Name

so i when i click on the firstName in my list box, it will show me the contact person in my main form

as i mentioned i have couple of people has the database open (split Database) anyone on the network, could see the update on the list box , but when they click on the new created name doesn't show in the main form, unless you close access, and reopen it again


i hope i was clear expaling,

any idea on how to have the List Box update itself without closing and opening Ms Access ??

thanks in advance

 

[zxmax]

Thanks Pat for the reply

what code should i use (eg: hidden botton) to fore to query

thanks again

 

[WayneRyan]

zx,

If one of the front-ends adds a record to a ListBox's rowsource,
the other front-ends won't know about it and won't requery.

If you need them to keep their lists up-to-date, you're gonna
have to do some action.

You could do something as simple as putting "Me.YourListBox.Requery"
as the code for a command button.

You could use some form event like the OnCurrent and it will refresh
as above when each record is displayed. Something like this could
cause a lot of network overhead (if it's a large list).

You could even do a DCount on the source table & compare it to
Me.YourListBox.ListCount ... requerying if there are different
counts.

Just some thoughts.

Wayne