Search results

HI, Im using this code to copy fields from the previous record in my form and put the copies field values into a new record on the form. HOwever the code doesnt work when it tries to find the previous values for any fields on a tab page other than the first one. I tried to change the focus to...

Could someone please tell me what Im doing wrong? I want to retrieve a record from my table (business details) based on the business selected in a drop down. But my code says its a new business every time, regardless of whether an existing business is chosen from the drop down: Private Sub...

Hi, I have a form which has fields connected to two tables. I have a drop down which should return all fields from one table when an item is selected from the drop down It worked in another form where I just had a text field but now I cannot get it to work with my dropdown. Any advice...

Hello, I have read about 2 dozen posts on this and it appears simple. Yet my code fails every time. I have 2 tables with data. I have a form with multiple tab pages. The controls on the first tab page all come from the first table. I have a drop down "Choose or Enter Business Name" which...

I have a clear (reset) controls button on each of my tab pages which clears all the controls in the subform on that page. However I would like to have just one button which clears all controls on all forms on all tab pages. Is this possible? I have a save button which resides outside the...