Help With Forms and Queries

[bryand]

I'm trying to set up a charge account system for our customers using access. I have set up two tables one with customer info the other with transaction info. I also set up a query to calculate the sums for each customers Transactions and Payments. Then I set up a form to calculate the balance and I encountered another problem. When I enter in a serial # to the form it associates itself with the customer name, however back in the query it will not and will make a seperate account for just the serial# leaving the name column blank. I think I will need to have the name in the query and associated with the serial # in order to run reports . If some could help me figure out how to do this or maybe suggest an easier way to fix this problem I would greatly appreciate it.

 

[downwitchyobadself]

I'm not sure I fully understand your post, but sounds like you need to be refreshing/searching after entering the serial number?

Where's the "back in the query" you're talking about? In the form, or in a report?

 

[bryand]

I'm sorry I meant in the query it will not associate the serial # with a name instead it makes a new entry with that serial and no name. The same serial # still shows with the name but none of the new transactions are added to it. I need to get the name associated with the # in the query, without messing up the rest of my form bmdsubs@hotmail.com