Hey everyone,
I created a form which users can fill the data fields (from few tables), and I want to save the data incerted as a new record in a specific table.
How can I do it?
Hey everyone,
I created a form which users can fill the data fields (from few tables), and I want to save the data incerted as a new record in a specific table.
How can I do it?
Bind form to table - set form's RecordSource property.
Data is committed to table when:
1. close table/query/bound form
2. move to another record on table/query/bound form
3. run code behind form to save record
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.
Hi there,
Are the form fields bound or unbound to the tables/query's?
Yes, controls on a form are usually bound to a field that is in the table/query that the form is bound to.
If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
Bob Fitzpatrick
Yes, I know that in Access, by default they are bounded, but are they in this case?(that was my question)
(btw I rarely bound anything I prefer doing it all VBA hardcoded)
only you can see that. open the form in design view - do the controls say 'unbound' or do they have field names? Alterntavely look at the control properties - is the control source blank? if so it is unbound.but are they in this case?(that was my question)
Since you say 'btw I rarely bound anything I prefer doing it all VBA hardcoded', I'm wondering if I am misunderstanding the question, since you would know that
Why not post a copy of your database and get direct, focused responses?
Even a screen capture of the form design and properties.
@Ajax, you are not responding to OP, that is another person asking for clarification from OP.
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.
OOPS