how to insert form entry into access table

[p4nny]

Hi

Completely new to Access!

I've added a field to an existing form.. How do I link this to the table?

The field is a textbox that uses the dlookup formula in the Expression buillder... I would to return this value in the table

Many thanks for your help

 

[Micron]

I would to return this value in the table

Not sure I understand completely. A form control can be bound to a table or query field if the form has that table or query as its recordsource. You set the control's rowsource property to be whatever field you want in forms design view. You cannot bind (link is not the proper term) a control that contains an expression (such as DLookup) to a table or query.

If your lookup is working, I presume you want to ADD the value to the table or UPDATE the existing value, not "return" it?

 

[p4nny]

Hi

Yes that is correct. I would now like to ADD this value the table..

Appreciate your help

 

[Micron]

Then create an append query that uses the textbox source as the value to be appended to the target table. In the 'update to" field of the query design view, you'd put the proper form and control references, something like: Forms!frmYourFormName.YourControlName. Notice that I didn't use brackets [] around the object names, because I NEVER use spaces in object names. You would run this query on some form event, such as a button click. For this, you have 3 methods to execute an action query, which I will leave to you to research and decide on which you want to use. Here is but one source for "ms access run append query vba" :
http://www.fmsinc.com/microsoftaccess/query/action-queries/SuppressWarningMessages.htm