By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,027 Members | 1,261 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,027 IT Pros & Developers. It's quick & easy.

Move selecetd data from a form to an unlinked table

P: n/a
Hi....

Using Access 2003..

I need help with the following...

I have a form with a series of option combo's which as selected,
filter data to the end chose..

I would like to record the final selected chose by moving the data to
an un-linked and separate table within the same database, which is
then a permanent record of the selection process for security reasons.

I did it once but can't recall how the code went ...

Appreciate any help
Thanks...

Sep 1 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Air code (untested):

Dim db as DAO.Database
Dim rs as DAO.Recordset
Set db = CurrentDB
Set rs = db.OpenRecordset(strQueryDefName)
rs.AddNew
rs("logdate") = Now
rs("fieldname1") = Me.txtControlName1
rs("fieldname2") = Me.cboControlName2
. . . 'set the other record fields from the
'user-entered values in Controls on
'the unbound form
rs.Update
rs.Close
Set rs = Nothing
Set db = Nothing

where strQueryDefName is a variable containing the name of the QueryDef you
use to open your Table, where "logdate" is a Field in your Record into which
you store the Date and Time of the update, where "fieldnameN" represents the
name of a Field in your Record, and where <prefix>ControlNameN are fields on
the Form.

But, even simpler, you could bind the Form to the Table where you want to
log the Choices, and open the Form in DataEntry mode, and they choices will
automatically be saved when you move off the Form.

Larry Linson
Microsoft Access MVP
<gs********@blueyonder.co.ukwrote in message
news:11**********************@r34g2000hsd.googlegr oups.com...
Hi....

Using Access 2003..

I need help with the following...

I have a form with a series of option combo's which as selected,
filter data to the end chose..

I would like to record the final selected chose by moving the data to
an un-linked and separate table within the same database, which is
then a permanent record of the selection process for security reasons.

I did it once but can't recall how the code went ...

Appreciate any help
Thanks...

Sep 1 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.