A newbie here, hoping someone can help with a confusing problem i have...

I've got a table of customer information (Autonumber ID, Name, Address, etc.). I have another table that is functioning as an action history - when you put a new entry into this table (History), you can select the customer from a dropdown list that selects from the customer table.

I have a form that is supposed to display the history for one customer that the user enters. The source of this form is a query that pulls information from the customer table, the history table and a few others.

Since there are a lot of customers and the user may not enter the customer name exactly as it is listed in the customer table, i've been trying to create a separate form that functions as a selector. The user selects the customer from a drop down list in this form, and then clicks the submit button to open the history-display form (the button is set to the function in the wizard that tells access to open the form and search for specific information based on what input is given from the first form, in this case, the customer ID autonumber).

My problem is this - I have four history entries in the table as tests. The form setup I just described works - but only for one customer. I cannot for the life of me figure out why this is - for this one customer entry it displays the history just fine; for the others, the display form is completely blank. since the variables are all selected uniformly from other tables, i don't know why this is happening.

Can anybody give me some help here? maybe some strategies for how to troubleshoot this problem?

You have a Form/subform for this?

there are several forms involved. you'll have to be more specific

I assume that the PK from Customers is the FK in History and you have a one to many relationship between them, in which case your main form has the fields you want from the Customer table and the sub form has the fields from the History table. If you link by the ID your sub will display relevant records.
HTH

i don't have any subforms. as i said, the user selects the customer from a list in one form. the submit button on that form opens another form. the second form's source is a query that pulls information from the different tables. this form displays the information.

now hang on...

i've narrowed it down somewhat. i went into my history table and started changing things. there's one field in the history table that is a lookup field - it selects the entry from a separate table.

when that field is anything other than one particular selection, the information won't display. otherwise, if you select this one item, it works.

why would that be?