Vba subform recordsource not updating cursors for updating
If you go on creating forms, tables and queries with this style you will get in troubles very soon. If you open your table you are not able to see the real values which are stored in the table but only the lookup values with a combobox.As the user never has to look into tables directly this is a useless feature which creates lot of problems later.I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing.Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S. Be sure that frm_booking_summary2 is open when this function is run.Since I am getting (a bit) frustated over this I would be grateful for some assistance.Probably it’s quite simple but I can not get it to work. rce] = str SQL which keeps giving me this error: Run-time error '440': You entered an expression that has an invalid reference to the property Form/Report. The form is called frm_booking_summary2 The subform is called frm_input_costs2 The subform's control on the form is called sfm_input_costs Any ideas how to get round what is surely a stupid error?
My problem is that I cannot set my subform recordsource dynamically.
I have a form with a combo box and a subform cotaining a table.
There is no bounded recordset for this form and/or child/parent relationships. Record Source = str SQL Note that My Subform Control Name is the name of the subform control on the main form, not the name of the form being used as a subform.
Helen - that is how I got the expression in the first place, hence the plethora of square brackets. mx I tried that, but of course come back to the original problem, but this time when trying to set the Filter property of the subform I've attached the database - in order to see the problem, open the one form on the Switchboard and chose an Accommodation Type, then tick the tickbox next to it legends-of-rock---Copy--2I wasn't concentrating - I was watching the Paralympics closing ceremony! In cutting down the size of the database to send to you, I accidentally deleted the subform. So now, when the form opens, go to the "Type" dropdown and then tick the tickbox and the fault will appear.
"It's a separate module, which is run every time a user updates a tickbox on the form." In a regular vba module that is not a Form module? Actually, Are you *sure* the Source Object (which would be frm_input_costs2) set on the Subform Control (sfm_input_costs) ? Hi, sorry to say that, but your database is full of problems and what you get is the result of a very wild mixture of all that.
If you search for lookup field problems in the Internet you will find a lot of answers about that. You have for example references for standard values in the unbound start and end date fields to another form, you have references to a specific form and controls in your queries and you have references to specific forms in your module although you use a frm parameter.