Search results

I am just wondering what event in what form (child or parent) did you attach this to, as I am going through a similar situation with my current db problem.

So in that case it would most probably be advisable to use an unbound form, populate specific fields from a query, and then Update/Append the table through SQL.

TechNat, not to hijack your thread but I was planning to post something similar and therefore thought it relevant. I'm presuming that if you had a select query that selected a single record to populate a form, and field/s were editted, then these changes would be automatically updated to the...

The form was working with the default form settings. But now that I have changed the layout, removing record navigation toolbar and forced the form to a new record OnLoad() textbox2 does not update. What would I be missing, I'm presuming that now that there can be only 1 record the OnCurrent...

Focusing the requery on the specific textbox worked a treat. Cheers.

Thank you for your reply. I've used the main form OnCurrent Property, and it does update the 'textbox2' with the required information. However there is a long delay !10seconds when starting the form, or trying to change a mainform record. Is there a simple way to overcome this.

I have searched for a solution to my problem but have been unable to find any pointers or assistance. I currently have a form that has 2 text boxes in the main form and a subform that contains the record data, the subform datasheet displays multiple records. The first textbox displays the...

Hello, firstly I do appreciate this forum and the advice given. It has been a great source of information whilst lurking and I have been able to slowly build my current database correctly with the desired result (well I hope). However, I have run into a problem that I can't figure out the...