Controlling a datasheet form with unbound text boxes

[BWD]

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.

Thanks

 

[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.

-Tom.
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