Query fields will not update after intial Entry

[Curben]

Hello all, two days of websearching and I cannot find an answer yet.

Reasonably new to access development.

Access 2000 DB using access 2003 on windows XP

I am having an issue with creating a query that I can enter the Part ID as value and hvae the description, cost etc. populate in the rest of the query.

I have two Tables; ItemMaster and [Initial Input]
[Initial Input] has one Value: [Part ID]
and ItemMaster has several but i have limited to Segment1, Description, Item_Cost

I want to create a form based on a query that when the Part ID is entered that the query runs and displays the rest of the information. This will later be appended to a table which will be followed up on by another user.

The problem I have is that the query will not update unless saved, closed and reopened, or switch views. So instead of Entering in the one value and the rest of the values filling in automatically, enter just goes to the next blank value.

I have done this several time before and they have all worked. One item that may make a difference is i just transfered to a new PC and attempted to change all the options so perhaps i checked/unchecked something i shouldnt have.

Any help or assistance can be appreciated

Thanks

SELECT [Initial Input].[Part ID], ItemMaster.DESCRIPTION, ItemMaster.ITEM_COST
FROM ItemMaster RIGHT JOIN [Initial Input] ON ItemMaster.SEGMENT1 = [Initial Input].[Part ID];
 

[puppydogbuddy]

Hello all, two days of websearching and I cannot find an answer yet.

Reasonably new to access development.

Access 2000 DB using access 2003 on windows XP

I am having an issue with creating a query that I can enter the Part ID as value and hvae the description, cost etc. populate in the rest of the query.

I have two Tables; ItemMaster and [Initial Input]
[Initial Input] has one Value: [Part ID]
and ItemMaster has several but i have limited to Segment1, Description, Item_Cost

I want to create a form based on a query that when the Part ID is entered that the query runs and displays the rest of the information. This will later be appended to a table which will be followed up on by another user.

The problem I have is that the query will not update unless saved, closed and reopened, or switch views. So instead of Entering in the one value and the rest of the values filling in automatically, enter just goes to the next blank value.

I have done this several time before and they have all worked. One item that may make a difference is i just transfered to a new PC and attempted to change all the options so perhaps i checked/unchecked something i shouldnt have.

Any help or assistance can be appreciated

Thanks

SELECT [Initial Input].[Part ID], ItemMaster.DESCRIPTION, ItemMaster.ITEM_COST
FROM ItemMaster RIGHT JOIN [Initial Input] ON ItemMaster.SEGMENT1 = [Initial Input].[Part ID];
 

Sounds to me like you have the setting "Confirm Action Queries" turned on. Go to the Command Menu, select Tools>Options>E dit/Find Tab>uncheck the box that says "Confirm Action Queries"

[Curben]

Nope, Was unchecked already.

I did check it test, uncheck test and nothing so far.

I have since tested on another database on another PC and i am also having a similiar issue there, so maybe it is just me.

[puppydogbuddy]

Nope, Was unchecked already.

I did check it test, uncheck test and nothing so far.

I have since tested on another database on another PC and i am also having a similiar issue there, so maybe it is just me.

By the way, the query that you are showing in your post is not an update query or insert query ...it is just a select query. This is not the query that you were talking about it not updating is it?

[Curben]

By the way, the query that you are showing in your post is not an update query or insert query ...it is just a select query. This is not the query that you were talking about it not updating is it?

Yes, this is the query I am refering to. The values will not populate in "real time"

I am trying to get this to a form that will show the data so when a user inputs the ID they will have the rest of the data to make a desision on. they will be able to either overtype the part ID if they do not wish to submit it, or move to the next record. I already have one query that does this for another project.

SELECT Processed.[Rec#], Processed.[Part ID], Processed.LPN, Processed.[DOA/DOI], Processed.Resolution, Processed.[Date Entered], Processed.FW, ItemMasterSynced.DESCRIPTION, ItemMasterSynced.ITEM_COST, ItemMasterSynced.[Source Pole], ItemMasterSynced.Modality, ItemMasterSynced.Category, ItemMasterSynced.Notes, ItemMasterSynced.[Where to send], ItemMasterSynced.Contact, ItemMasterSynced.Address1, ItemMasterSynced.Address2, ItemMasterSynced.City, ItemMasterSynced.State, ItemMasterSynced.Zip, ItemMasterSynced.Phone, ItemMasterSynced.Location, ItemMasterSynced.O1vt, ItemMasterSynced.Reason, ItemMasterSynced.Source, Processed.User, ItemMasterSynced.XelusLU
FROM ItemMasterSynced RIGHT JOIN Processed ON ItemMasterSynced.SEGMENT1 = Processed.[Part ID];

This does the same thing just with alot more Fields

[puppydogbuddy]

Ok, so all you are trying to do is populate your form, you are not updating anything, you are just displaying information from your table.

1. When you run the query by itself, independent of the form, does it display the data you want?

2. Do you have just a main form, or do you have a main form and a subform?

3. Is the form bounded to the query by referencing the query in the form's record source property?

4. Are the controls (textboxes,etc) bound to the table via their control source property?
5.Do you have any code behind your form setting form and control properties?

[Curben]

I cannot get to the form, as the query will not populate the values in the rest of the feilds in real time.

I should be able to enter the data directly in the query and the query should complete for that value, go to the next record, and do the same, it is not however. when i type the part ID into the field part ID
and go to the next record, the rest of the values remain blank until i manually refresh the query

[puppydogbuddy]

I cannot get to the form, as the query will not populate the values in the rest of the feilds in real time.

I should be able to enter the data directly in the query and the query should complete for that value, go to the next record, and do the same, it is not however. when i type the part ID into the field part ID
and go to the next record, the rest of the values remain blank until i manually refresh the query

You lost me.
You do not need the form to run the query. Run the query by itself.

What happens?

[Curben]

You lost me.
You do not need the form to run the query. Run the query by itself.

What happens?

The query runs fine, it just will not run in real time which will be needed once the form is attached.

In layman's english, when you enter a value in the first field when the rest of the fields are tied to another table, then once you press enter to lock in the value, then the rest of the query does not run. It WILL run if i close the query and reopen it, or if I switch to design view and back. But the query will not run on entries I make while i still have the query open.

[puppydogbuddy]

The query runs fine, it just will not run in real time which will be needed once the form is attached.

In layman's english, when you enter a value in the first field when the rest of the fields are tied to another table, then once you press enter to lock in the value, then the rest of the query does not run. It WILL run if i close the query and reopen it, or if I switch to design view and back. But the query will not run on entries I make while i still have the query open.

Ok, I think I see where the confusion is. You really want a parameter query...where you can enter a value and have the rest of the info returned. Let's do this:

1. Place your query in design view
2. In the criteria row of the first field in your query grid, type the following:
[Enter a value]
3. save your query and run it
4. Tell me if that is what you meant.