Problem getting a field to populate

[punter]

Hi,

I'm having a problem with the attached database. There is a form called Broker_Information_Entry. The first field of that form is called BOL_Number. There is a query called BOL_Number_to_pull_up_Unique_Number.

Here is what I want to happen and then I'll tell you the problems I'm running into:

1-Data is entered into the first field called BOL_Number.

2-The querry called BOL_Number_to_pull_up_Unique_Number is activated. It is set up to run depending on the text entered into BOL_Number.

3-The second field named Unique # is populated from the data pulled in the BOL_Number_to_pull_up_Unique_Number query.

I'm almost there (I think) but I can't get it to work all the way. The problems are:

1-The BOL_Number_to_pull_up_Unique_Number does run correcly after data is entered into the BOL_Number field but only if I manually activate the query. How do I get it to run automatically?

2-How can I get the data from the BOL_Number_to_pull_up_Unique_Number to populate in the Unique # on the Broker_Information_Entry form? It seems as if I have the field in the form currently pointing to the right spot on the query but nothing is pulling through.

Any thoughts would be most welcome. I've really only been using access for about a month or so. I can see what an awesome toy it is.

Thank you all for your time and help.

Eddie

 

[jmrSudbury]

Make the combo box bound to the BOL_Number_to_pull_up_Unique_Number query. In the after update subroutine of Bol_Number put this code: me![Unique Number].requery

John M Reynolds