Select Query

  • Thread starter Thread starter Jason Frazer
  • Start date Start date
J

Jason Frazer

I have a Select Query called [MSDS Query] that references
3 Tables. The Tables are [Product], [MSDS] and
[Customer]. All tables have a key that is an autonumber.
I have a relationship between the product and msds query,
but I'm not sure what relationship to use. Let me explain
the problem. First the user will input all the
information into the product form witch uses the Product
table as the control source. After that they go the MSDS
form with uses the [MSDS query] as its control source.
The problem i'm having is the product add to the [product]
tables does not display in the [MSDS query]. If i go in
and add the Rec No and Product name manually to the [MSDS]
table than the product will display in the Query.
How do i get the added product to display in the MSDS
query?

Thanks for your help

Jason Frazer
 
Anytime data is added to a table, an open "queries", and I use this loosely
because this means any controls based on the table such as a Combobox or
listbox, MUST be refreshed.

So, I don't understand exactly how you are adding data, but when the action
is completed, you'll need to issue a requery.

i.e. cboMSDS.requery


--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Back
Top