Append Query that prompts the user to enter the new information

[kmw]

I want a query that will add new entire rows of data by prompting the user to enter it. Ultimately I plan to put this query info a form.

[June7]

Query input parameter prompts is a poor method for data entry. That's what forms are for.

[kmw]

Query input parameter prompts is a poor method for data entry. That's what forms are for.

A form to enter new employee information

[June7]

Does not revise my advice.

[kmw]

What would you advise?

[June7]

I advise you build a form for data entry. The form RecordSource would be a table or an editable query. Bind controls (set ControlSource) to the fields of the RecordSource. Entries in controls pass directly to the table. This is very basic Access functionality and Access Help has guidelines or google for tutorials.