how to get from here to there

[killerleaf]

ok, I am really really new at all of this,... and I really am stumped how to get this to what I want it to do....

here is what I want:

I want to run a query (be able to have a box pop up to input query) (query fields would be any of the fields in the table) (it would pull records from a table already populated) then it would pull all matching records into a form, where I can find the one I want, so I can enter data via the form, and then put the completed record into another table.

It needs to be seamless, if at all possible, because the people who will be entering the data just want to be able to click and enter the data.

Any and all help is really appreciated!!

 

[killerleaf]

just as a point of clarification:

I know how to do a query, I know how to do a form, but I don't know how to get to work....I have this feeling that I need to break the process down into smaller steps or something, but I just am not seeing it. ray: ray: ray: please, please help!!!

 

[jobb]

I'm not sure I understand your question.. you basically want a form based on a query, that you can input data into, and then append your finished record into another table? Please clarify what you want to do.

 

[killerleaf]

you summed it up perfectly.

 

[Greg Truby]

Maybe I'm over simplifying but why don't you just use the form's properties to set the RecordSource to the Query?

Or it you're filtering by one (or maybe two) straightforward criteria use the filter by form tool?

 

[killerleaf]

thank you! like I said, I am very new at this, and did not know you could set the recordsource like that....I will give this a try!