Requerying a list box with Sql server table data

[hansdbase]

I don't have a persistent link to the sql server database. The form pulls data from the tables in sql server when it needs it. But I have a list box in the form that I want to occasionally requery when the user adds another record that will be populated in the sql server table. I have code that links the table, populates the new record, and then drops the link. After that is done, I want the listbox to requery to show all of the values including the new one just added for the table. I don't see a property field that will allow me to use a recordsource from a sql server database table that is unlinked. Do I have to have code create the connection, update the listbox from sql server, and then drop the link again? Or is there an easier way?

[June7]

Requery listbox before dropping link?

[hansdbase]

Requery listbox before dropping link?

Thanks. Sometimes the best ideas are the most simple ones. I still have to programmatically load it the first time the form opens because I can't set the rowsource to a table that doesn't exist. Is there any other way around that? If not, no big deal. This was helpful.

[June7]

Not that I know of for pulling data from SQLServer.

[Gicu]

A simple pass-through query would do. If you are concerned about users looking at the Connect string property of the that you can set it in the load event of the form instead of having it saved with the query object itself.

Cheers,

[June7]

If users do not have access to navigation pane and can't open objects in design view, they could not see connection string property of PTQ.

However, as far as I can tell, cannot edit data via PTQ so don't see how it could be useful as form RecordSource. No idea how to set PTQ connection property during load event of form.

[Gicu]

I thought we were talking about populating a listbox now.

[June7]

Both? "I have code that links the table, populates the new record, and then drops the link. After that is done, I want the listbox to requery to show all of the values including the new one just added for the table."

[Gicu]

Yes, but the first part is done (the adding of the new record from an unbound form). But the OP now wants to populate the listbox when loading the unbound form and refresh it after inserting the new record. Which I believe can be easily done by using a pass-through query which can be saved or, if there are concerns, have its .SQL and .Connect properties set in the form's load event (using a QueryDef object).

At least that is my understanding of the issue.

Cheers,