Combo Box Won't Return Results in Query

[Michelle]

I'm using Access 2002 for the first time in a long time and seem to be really
rusty. I'm trying to set up a very simple accounts receivable database that
will print statements.

I have a table with the customers' code and their details, and I've used a
combo box linked to the customer code field for the data entry form which
dumps its data in a table with the code, invoice date & #, and total. I'm
trying to set up a query that will dump all the branches of the same company
in one dynaset.

I've based the query on the table that is created by the form, with the
combo box, the date, invoice number and total fields. The company codes are
3 letters, so I've tried using the criteria line and the codes I'm looking
for in double quotations on the combo box colu. The query will run fine,
until I use this criteria line, and then I get no results. This worked fine
until I changed the customer field to a combo box, so I'm assuming it's
something I'm doing wrong with that, but I'm lost and completely frustrated.
I've spent hours struggling with this.

Any help anyone can offer is GREATLY appreciated.

Michelle

 

[Michelle]

I'm using Access 2002 for the first time in a long time and seem to be really
rusty. I'm trying to set up a very simple accounts receivable database that
will print statements.

I have a table with the customers' code and their details, and I've used a
combo box linked to the customer code field for the data entry form which
dumps its data in a table with the code, invoice date & #, and total. I'm
trying to set up a query that will dump all the branches of the same company
in one dynaset.

I've based the query on the table that is created by the form, with the
combo box, the date, invoice number and total fields. The company codes are
3 letters, so I've tried using the criteria line and the codes I'm looking
for in double quotations on the combo box colu. The query will run fine,
until I use this criteria line, and then I get no results. This worked fine
until I changed the customer field to a combo box, so I'm assuming it's
something I'm doing wrong with that, but I'm lost and completely frustrated.
I've spent hours struggling with this.

Any help anyone can offer is GREATLY appreciated.

Michelle

Hi Everyone

Thanks to everyone who's been puzzling over this one. I was so frustrated
with the problem I just deleted everything and started over, and the problem
isn't there anymore. I'm sure I'll need more help with other stuff.

Thanks

Michelle