Form to table

[Schillers]

To create A query that just takes some of the information from a form and insert it to a table? I would like to specify the form fields and table field?

 

[Alansidman]

Are you trying to use an unbound form and update a table? Is there a particular reason for this if it is the case? If it the case, why not have your form bound directly to a table so that it updates automatically?

 

[Schillers]

Hey,

Its just the fact that I have a list box that retrieves its values from a query but I need to input the selected result to a table? If i bind it to the table I want it in it then doesn't let me choose any of them?

 

[Alansidman]

ok. Look at this video on how to use an unbound form to update a table.

http://msdn.microsoft.com/en-us/library/bb225982(v=office.12).aspx

Alan

 

[Schillers]

That doesn't seem to be a video?

 

[Alansidman]

Oops. Gave you the wrong link. My apologies. Try this one.

http://www.datapigtechnologies.com/flashfiles/addformrecordsnocode.html

Alan