Also, is it possible to have a form to collect user input, then add that input to a table?
Competent Performer
Windows 7 64bit 
Access 2013
Also, is it possible to have a form to collect user input, then add that input to a table?
Sometimes Helpful
Windows XP Access 2003
Yes and yes.
You can bind a form's recordsource to a query. You can have subfomrms within main forms.
Forms are good for displaying data. Forms are really good for collecting user input and updating recordsets.
Competent Performer
Windows 7 64bit Access 2013
How could a form be connected to more than one table when you can specify only one table in the Record Source property?Originally Posted by ItsMe
VIP
Windows 7 64bit Access 2010 32bit
Use query as RecordSource. Query can join tables. However, can edit only one table through a form. The query will allow display of related info from joined tables but edit can only be done on one table through bound form.
Use form/subform arrangement to edit multiple tables with a parent/child relationship. The form/subform will give the appearance of a single form.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Sometimes Helpful
Windows XP Access 2003
Build a query and save it. Then bind the form to the saved query's name.
Setting a variable on one bound form from another table
Using a value from an table not bound to form
Posting Permissions
Reply With Quote