Search results

Thanks Rural Guy, Had read that while digging around on the net. Was hoping that there may be a better/easier work around. It does kind of make sense. Will handle the displaying of the selected record differently. Perhaps via vba on form load or something. All records show by default on form...

Hi, I hope everyone is well. I have a form with datasheet subform that lists orders. On the main form I have an unbound text box called txt_order. The purpose of this control is merely to show (order number for) which record is selected in the subform. The control source for this control...

Ok I did an experiment - the problem only occurs on the add new request main form not the edit version of that form. I tested and removed the onload event which basically: went to a new blank record acnew; and created a new ID for the primary key of the main form Also in the property sheet of...

As the main form adds a new record when you press the save button wouldn't a refresh/requery go to a new blank record/run the create new request number on form load event again?

Hi Nautical Gent, Thanks for your time to take a look. The main form which is the stock request has an onload event that generates the stock request number. The subform has no events associated with it. The add new item button is on the main form and when you click it it opens a add new item...

Hi, I have a really strange problem that I have never encountered in access before. I am using access 2007 and have a main form with a subform datasheet. The main form is a stock request and the subform lists items that are requested as stock as part of the main request. I have add edit and...