Search results

I should clarify: I could not get this particular entry form to work using bound controls. Here is the link to this particular thread. Thank you Reset combobox if user clicks another form

I have a form with two subforms; one in the header and another in the detail area of the main form. The header (form) is used for data entry and contains all unbound controls. The detail (form) has bound controls in continuous view with an Edit button at the end of each record row. Problem: I...

I finally got this working by removing all bound controls from the header. thanks for everyones insight.

I'm losing my mind. Ok, so after entering the above, now click the Reset button and clicking into the subform.. Perhaps its an issue with the Reset code.

To duplicate the error: Update any control on the header form. Then click on any part of the sub form. You will receive the original message "The Microsoft Access database engine cannot find a record in the table 'tblTrucks' with key matching field(s). TruckNumberLookup."

Hi again! Yes, you got me this far. I believe I may have figured out what Doc was saying but I'm getting a new error 'You must enter a value in the 'tblMeterReadings2.MeterTruckNumber' field. I think this is because I need to find a way to clear the changed value of the combobox back to default...

can anyone help?

Hi Doc, thank you for your insight. I'm not 100 percent sure I follow however please allow me to provide some clarification as I've further found the error appears when a value is entered in ANY control inside the header, then clicking off of the header form. It also seems this action is...

I have a form with two subforms; one in the header and another in the detail area of the main form. The header is used for data entry and contains a bound combobox which allows other controls inside the header to be populated specific previous record information found in the detail form...

Ok, I found where you wrote the code which makes sense now. Thank you for your help!!!

you're right; typo on my part. I spoke with the user and these numbers would only increase; they would never decrease.

I was thinking about this, would it be easier to have this work by using the bound control for meterdate; like date - 1? Whichever way is fine with me

That looks correct except Truck93 shows today's entry; the rest are correct though.

Touche. Good point. try this one :-)

Hello everyone! I have two subforms on one main form. The detail form is a continuous form called 'qryMeterReadingsForm.' I'm trying to create a textbox control on the header form and set it equal to a prevoius record from the query (or table) that matches whatever is selected in the combobox...

That's awesome! Thanks so much for the quick response and explanation.

I have this exact code working in another Access database which I have modified the code to match the controls on the new database. I'm trying to filter a single continuous form using multiple search criteria. The code works for all controls in the header except the combobox. I believe this may...

This particular form will rarely be used; it was a replacement for one built with MS works. I'm not sure how to insert rows dynamically so I kept it as is. However if you can be so kind as to point me in the right direction I'd like to check into it. Thanks

Thanks! That did it.

Hanks doe your response. Does that mean it would just bypass that portion of the code if the user answers no? Everything appears to work ok otherwise. I’ve never just wrote error handling. Could you provide some assistance?