NEW RECORD ISSUES

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Sounds like your combo is a bound control. Combo's used for looking up
records should not be bound controls.
 
Back
Top