Data Entry Problem

[superhorse]

Hi,

In my database I have a form with client details on, then I have a subform where data is entered for specific jobs done for the clients. When I select a client from a dropdown list on the main form, the job details come up on the subform.

I want the subform to default to a new record when a client is selected. I set the properties of the subform to data entry, which works when the form is first opened, but whenever a new client is selected is goes back to showing the first job in the list.

Is there any simple code which would slove this problem. Any help would be appreciated, thanks.

 

[maxmangion]

try the following:

DoCmd.GoToRecord , , acNewRec

 

[superhorse]

This may seem like a stupid question but where would I put this code because nothing is happening at the moment

 

[maxmangion]

you can try putting that code on the OnGotFocus event of your subform

 

[superhorse]

I have tried that code on the 'OnGotFocus' event as well as a few other events and it doesn't seem to make a difference.

 

[dkinley]

Place it in the AfterUpdate() event of the drop down box on your main form.

First, you will need to put the focus on your subform and then the new record.

-dK