Query display on a form

[lous]

I have a database that has two forms, two tables, and a query. Here's what I would like it to do, but can't figure out how to do it.

The first form contains an account number text box. After the person types in this account number, it should run a query that pulls the name and address from another table.

I can get it to work by clicking a button and showing that information in a subform, but I need to display on the main form instead.

How can I get the information from that query to show up on the main form?? Perhaps I'm making it much more difficult than it really is.

Can anyone help?

Thanks

 

[ToeShot]

you could build a form based on the query and use that as your main form

Dave
ToeShot@Hotmail.com
Today Is Tomorrows Yesterday. So Why Wait

 

[lous]

This does work, except for one problem. One of the recordsets is not updateable and the other is just a table that should be updateable.

Now with the two combined, for some reason, it thinks that the table that is supposed to be updateable can't be updated.

So now I can get the information displayed on the form as I wanted, but I can't change anything at all on the form.

Any ideas?