Populating table from combo box

[mcguires99]

Still trying to solve this. I have 2 tables, 1 is tbltripNumber from whose data when populated I will create a report. 2nd table tblFromTo which contains 3 fields. 1 is ID, 2 is place names, and 3 is contracted days. This table used for my combo box. when a place name is chosen from combo box a resulting number of contracted days is placed in another field - "Contracted Days" on the form frmTripNumberDurations. This all works fine excet the contracted days doesnt fill in the tblTripNumber but does on the form. Likewise the "Demurrage days" also a correctly computed field shown on the form also does not populate in the tblTripNumber.

This plus the form showing #Name? when ever I visit it the next day after it working fine the previous day are the two problems.

[pbaldy]

Does this help?

http://www.baldyweb.com/Autofill.htm

[pbaldy]

Cannot see anywhere I can send you a word document . No post reply only reply which appears not to have that facility. Also cannot see advanced areas??

Either of the circled buttons should take you to a place where part way down is a Manage Attachments button.

[mcguires99]

Please see attachments

[pbaldy]

Not sure what you're saying the problem is. In image 1b, the error message appears to contain the incorrect table name (there is no "/" in the actual table name, according to the picture).