SQL tables in Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm using the following query in Access. I use this query to add controls to
a form.

SELECT QUOTE_DETAIL.Item_Number, QUOTE_DETAIL.Freight, QUOTE_DETAIL.Markup,
QUOTE_DETAIL.Item_Description, QUOTE_DETAIL.Size_Description,
dbo_ITEM_MASTER.MILL_NUMBER, dbo_ITEM_MASTER.MILL_COST, QUOTE_DETAIL.Price,
dbo_ITEM_MASTER.PRICE4
FROM QUOTE_DETAIL LEFT JOIN dbo_ITEM_MASTER ON QUOTE_DETAIL.Item_Number =
dbo_ITEM_MASTER.ITEM_NUMBER;

When I enter a value into the form [QUOTE_DETAIL.Item_Number] it should, and
does pull up these values from another table
[dbo_ITEM_MASTER.MILL_NUMBER];[dbo_ITEM_MASTER.MILL_COST].

Here's the issue, if the table that the data is being retrieved from is a
sql table, as it is above, the data doesn't 'pop up' into the form
immediately, the controls appear empty and I have to do one of two
things...Advance 1 record and come back, or close and open the form OR insert
a DoCmd.Requery command to update the data.

If Access tables are used in place of SQL the data pops up immediately as
soon as the control is updated.

Does anyone know why this happens and is there a way around it? The re
query command is clumsy.
 
You might want to repost with some more detail. I can't figure out what it
is that you're doing... is the form bound? is the control you're entering
the value into bound? is it using any code when the Access version works as
you want?


beeyule said:
I'm using the following query in Access. I use this query to add controls to
a form.

SELECT QUOTE_DETAIL.Item_Number, QUOTE_DETAIL.Freight, QUOTE_DETAIL.Markup,
QUOTE_DETAIL.Item_Description, QUOTE_DETAIL.Size_Description,
dbo_ITEM_MASTER.MILL_NUMBER, dbo_ITEM_MASTER.MILL_COST, QUOTE_DETAIL.Price,
dbo_ITEM_MASTER.PRICE4
FROM QUOTE_DETAIL LEFT JOIN dbo_ITEM_MASTER ON QUOTE_DETAIL.Item_Number =
dbo_ITEM_MASTER.ITEM_NUMBER;

When I enter a value into the form [QUOTE_DETAIL.Item_Number] it should, and
does pull up these values from another table
[dbo_ITEM_MASTER.MILL_NUMBER];[dbo_ITEM_MASTER.MILL_COST].

Here's the issue, if the table that the data is being retrieved from is a
sql table, as it is above, the data doesn't 'pop up' into the form
immediately, the controls appear empty and I have to do one of two
things...Advance 1 record and come back, or close and open the form OR insert
a DoCmd.Requery command to update the data.

If Access tables are used in place of SQL the data pops up immediately as
soon as the control is updated.

Does anyone know why this happens and is there a way around it? The re
query command is clumsy.
Click to expand...
 
Back
Top