Saving a new record

[justme4]

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?

[June7]

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

[AppBuilder]

Hi there,
Are the form fields bound or unbound to the tables/query's?

[Bob Fitz]

Yes, controls on a form are usually bound to a field that is in the table/query that the form is bound to.

[AppBuilder]

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)

[CJ_London]

but are they in this case?(that was my question)

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.

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

[orange]

Why not post a copy of your database and get direct, focused responses?
Even a screen capture of the form design and properties.

[June7]

@Ajax, you are not responding to OP, that is another person asking for clarification from OP.

[CJ_London]

OOPS