Form Textbox fed values from another textbox but not added to table as a recordset?

[djspod]

Hi,

I have form which is bound to a table, most of form items populate records in the table fields other than 2 table fields that are fed values within the form via vba.
These fields remain blank?

I know I am missing something somewhere that's probably straight forward but what?

Can anyone help please

Thanks



Darren

Sent from my SM-G935F using Tapatalk

[andy49]

Can we see some code which you think should be working?


Sent from my iPhone using Tapatalk

[djspod]

Hi ,

I have added the DB and a screenshot.

The fields highlighted with a red rectangle box are the fields that don't add to the table for some reason?

Thanks

Darren

[Bob Fitz]

To save the data displayed in a form control to a table field that control would need to have its Control Source property set to the name of the field in the table.
If the data displayed is "calculated" with vba code or in the forms underlying query it might be better not to save the result but better to recalculate it whenever and wherever it is needed

[ssanfu]

I agree with Bob.

For the control "ProductDesc" (Product Description), the control source is a calculation. Effectively, the control is unbound.

For the control "text3" (Producing Site), the control is unbound. ("Text3" is a bad control name)
(An unbound control is a control that is not bound to the form record source.)

You will have to come up with a method to save the values to the table.

I would bind the controls to their respective fields.
Then, for the Product Description (control name "ProductDesc"), I would use the after update event of the control "cboLineNo" to calculate and push the calculation into the "ProductDesc" control.

And for the Producing Site (control name "text3"), all you need to do is bind the control to a field. There is already code to push a value into the control.



And I would suggest you change the look up FIELDS in table "tblQualityReportData" to standard (non lookup) fields.
See
The Evils of Lookup Fields in Tables
http://access.mvps.org/access/lookupfields.htm

The Ten Commandments of Access
http://access.mvps.org/access/tencommandments.htm

[djspod]

Hi All,

Thanks for your constructive and useful comments.

I remember seeing that Lookup issue before (Evils of Lookup via tables) but had forgotten about this good tip.

I take on board the information supplied.

I will reword text3 and bind to a table control, for the other CBO, I'll create a qry and use a cascading combo effect but at the same time bind to a table control field.

It looks like the answer was staring me in the face!

Thanks for the help guys

Darren