Recent content by gagetpro

Yes! But must remove the extra paranthesis Me!txtReceiptNumber.DefaultValue = DMax("[ReceiptSlipNumber]", "M_ReceiptSlip", "[ReceiptSlipSites_IDs] =" & Me!cboSites_IDs) Thanks

Hello- I am trying to set the default value of a forms text box to the max value in a table. I can’t seem to get the code right Me!txtReceiptNumber.DefaultValue = DMax("[ReceiptSlipNumber]", "M_ReceiptSlip"), "[ReceiptSlipSites_IDs] = cboSites_IDs") Where txtReceiptNumber is text box on...

Continuous form Everything worked out great. Thanks again for your past help. I have a slight variation on this issue, that perhaps you could help. My form also has a subform that is continuous and has a pair of related combo boxes. When I input a set of values it seems to work just like...

:):) This is my first post. Your sample did the trick. Thanks again. I would suggest making tblStore lng1, lng2, lng3 number data type for consistency. Also perhaps a descriptive label on the forms- especially frmCreateData. eg " this form populates all 3 level tables with data. Otherwise...

Thanks Cosmos75- This is EXACTLY what I was trying to do. I will try tio figure out how you did it and get back to you if any questikons. Thanks for your time

cosmos- A very nice database however it accomplishes only displaying the records BUT does not bind/ place the records in a detail table. CascadeCbo2000 has only 3 tables one for each of the combo boxes. I am trying to store the selections is a additional table- along with other data of...

cosmos75- Thanks for the link. A brief look- looks good. It will take a while to review the entire approach. Will report back how it goes. thanks again

lagbolt- Thanks for your response. Yes- I would like to display the text in the combo box & store the combo boxes control source property to a tables field (foreign key). The form is bound to this table. My data base is normalized so I have a separate lookup tables for the values in the...

Hello- I habe searched the topics and read numerous posting- but none seems to address binding the results of a combo box. I have cascaded 2 combo boxes using after update event code but can't seem to get the results bound to a table. I get wrong data type error- text is returned by combo...