Subform problem

[punter]

Hi,

I'm plugging along on a database taht I have been building for a while. Many of you hear have been most helpful.

I'm running into a problem with a subform that I have. The form in question is called Broker_Information_Entry. The details/problems are:

1-The first field BOL_Number has a number along the lines of APLU031632305. That is an actual example out of the database.

2-The second field is named Unique Number. It is poplulated from a macro that performs a dlookup off the BOL_Number.

Everythign works okay up till that part. After that is where I'm running into problems.

I have a subform inside the the Broker_Information_Entry form. I want it to populate the details of the Unique Number in step # 2 listed above. I built a macro the runs upon exit of the Unique Number field. That macro activates a query called 02-28-07Query.

The problems I'm running into are:

1-I don't actually want to see the query that is run when the macro is fired upon exit of the Unique_Number field. I want it to run but don't want to see it.

2-I want the details of the 02-28-07Query to populate the subform inside the Broker_Information_Entry form. Currently nothing is populating the subform after the macro is fired and the query is run.

Thank you all so much for your time. Any thoughts are welcome.

Eddie.

 

[punter]

I'm getting closer. I got the query to open and close. The problem I'm having now is with the subform. I can't seem to get it to populate once the Unique Number has been entered on the main form. Any thoughts?

Thanks

Eddie.

 

[reada]

A Good Company

I would just like to tell you guys about a company that I had a great experience with, check them out at microsoft

 

[punter]

That last reply was spam. My post is real. Moderator please don't close it down.

Thanks

Eddie.

 

[punter]

I was able to figure it out. Thank you for you time anyway. I'm sure I'll have other questions soon enough.

Eddie.