Re: [MSAccessProfessionals] Form not working as expected

My typical strategy is to allow the user to search for the customer in the drop down. If they don't find a record, ask them to click a button to add a new customer. This button would open a customer form in dialog mode for them to create a new customer record. The code following the dialog form opening would requery the combo box and perhaps position the combo box to the most recently added customer.

Duane

---

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of M Garcia via groups.io <toukey1=yahoo.com@groups.io>
Sent: Monday, May 18, 2020 1:01 PM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: Re: [MSAccessProfessionals] Form not working as expected

 

Yes - the first column which is the CustID field was 0" so I changed it to 1".  After that change and I entered a name in the combo box I got the error "The value you entered isn't valid for this field."

On Monday, May 18, 2020, 01:11:04 PM AST, Paul Baldy <pbaldy@gmail.com> wrote:

The obvious first question is did you address the issue noted in the error message?  Presuming the bound column is 1, the first column width can't be 0.

Paul