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

 

[Linq Adams via AccessMonster.com]

I started to write that an unbound form only contains one record, but in
point of fact, it contains no record at all. All it does is hold data that
has been entered.

Following Tom's post, you can bind the form to a temporary table, and then
append the records to a permanent table, but once again, the important
question is ***why*** you're using an unbound form. The reasons given by
posters are usually based on misunderstandings on their part.

Bound forms and the rapid develpment they allow are a huge part of Access'
strength. To be honest, if you're not going to use bound forms, you'd
probably be better off developing your app in another language, like Visual
Basic or VB.Net, with an alternative backend like Oracle or SQLServer. There
would be no more work involved, you could distribute the app as an EXE file,
not dependent on some version of Access being on board each machine, and the
security would be much better than that available with Access.