Show a query in a datasheet

[pygnodev]

Hi to all,
I don't know if its the right forum to post, if I'm wrong forgive me.

I'm trying to develop a werehouse database for me.
and I'm in a terrible dead end.

Formely I have a table Articles where I have all the articles on the market with the description, EAN, price. and a table Movement where with a code (related with the article's table) I can store all the item I fisically have in my werehouse and items I sell. (with a boolen field that set if the item is an income or an outcome).

Now...I'm try to setup a form and I need this:

• I have a form linked to the Movement Table
• I'd like to write an EAN in a textbox
• query that EAN to the article table and output the results in a datasheet.

How can I do this? I don't know so much of VBA.. =( and I always have problem with subform =(

Thank you in advance

I've have had an image but I couldn't post it for the post limitation

 

[pygnodev]

no one can help me? =(

 

[cricketbird]

On your form, create a new combo box where you will enter the EAN you are searching for. Access will give you some options for the behavior for the combo box. Choose the "Find a record on my form..." option.

Next, create a query that includes the EAN and the other info you want to know about the EAN.

Finally, create a subform in datasheet view based on your query and insert it onto your main form. Link it by the EAN field. Now, when you search for the EAN, your main form should move to that record and the subform should update to list the info about that main EAN record.