Controlling a datasheet form with unbound text boxes



Hi All

I have an unbound form set to Dataasheet view that uses 5 unbound text
boxes. I would like the form to add a new line each time I have
completed one row of data entry and then have my Insert Into query
grab eaqch line of data as a separate record to insert into my table.
Is this possible?

I cant seem to get the datasheet view to add another line at the end
of each completed record.


Tom van Stiphout

On Sat, 31 Oct 2009 09:11:09 -0700 (PDT), BWD

No. You will have to bind those controls to an underlying table. Then
you get this behavior automatically.

Microsoft Access MVP

Larry Linson

An unbound form in datasheet view doesn't make a lot of sense to me. What
are you trying to accomplish?

From your description, it seems you could do what you want with a form with
the "Allows additions" set to yes in the "Data" tab of its Properties
Dialog. That lets you type in new records and automatically writes them to
the Form's RecordSource when you move to another record or close the form or
take specific programmatic action to write the record.

Larry Linson
Microsoft Office Access MVP

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question