NEW RECORD ISSUES

[Guest]

Hi,

I have a New record button in my main form. In the click event i have

DoCmd.GoToRecord , , acNewRec command to add a new record. this seems fairly
simple.

When i click on it I can create a new record. The problem arises when i
select other records using a combo box the value is retained for that
selection and when i click the new button again the record is focused on the
most current record selected with other feilds blanked out.

How can i code to clear all values including ensuring the combo box field
accepts the new record value.

thanks in advance

 

[Guest]

Sounds like your combo is a bound control. Combo's used for looking up
records should not be bound controls.