Error autopopulating form

[Traceyann1964]

Hi I have a form with a combobox which autopopulates fields such as name and address.

I am going to add a subform which will calculate values for an invoice. I want the main form to be blank when I open it so I therefore need to set the main form properties to data entry (yes)

As soon as I set the data entry to yes, the fields no longer auto populate.


Frustrating as I have done this before on a previous database so I know it can be done. Any ideas what I am doing wrong?

[ranman256]

yes, you can autopopulate, but after starting a new record, you MUST save record with the Client key.
It cant populate the sub form data until the key is saved.

[Traceyann1964]

Many thanks for your help. I am just a novice and don't quite understand. I wonder if you could explain further? Ive no idea about coding etc. Thanks in advance

[Missinglinq]

Sorry, but when you set Data Entry to Yes, the Records you're trying to retrieve, using the Combobox and the third option, don't exist, as far as the Form is concerned! Open the Form, with Data Entry to Yes, and look at the Navigation portion of the Form...instead of saying

Record 1 of n

where n is the number of Records in the underlying Table...it will always say

Record 1 of 1

Set Data Entry back to No and use this code to move to a New Record (which will be blank) when opening the Form:

Private Sub Form_Load()
  DoCmd.GoToRecord , , acNewRec
End Sub

Linq ;0)>

[Traceyann1964]

Thanks for your help but it didnt work.
I have a combobox to autofill name and address, vehicle make and model which works perfectly. I then plan to add a subform to allow the user to add values for an invoice so each time the form is opened it will techinally be a NEW invoice so needs to be a data entry from. I added the code DoCmd.GoToRecord , , acNewRec in the "on load" property but it hasnt worked

[Missinglinq]

Have you set Data Entry Property of the Main Form to No? Despite its name, Data Entrydoesn't need to be set to Yes to enter data...it means you can only enter New Records, not view/edit existing Records.

Linq ;0)>

[Traceyann1964]

Thank you for your reply. Yes it is set no. Maybe something else in the form is wrong. I just want the form to open with no data showing. The user will then choose a customer from the combobox and it will autofill the customer name, address etc then from the subform, the user will add the invoice details so technically, the user wont be entering data into the form (only the subform) but they will still need to select the customer from the combobox. Hope thats not confusing

[Missinglinq]

Only other suggestion I have is to zip up your file and attach it here for us to look at. If you can save a copy in format for an earlier version than 2010 I can look at it; barring that, I'm sure someone else will be happy to do so.

Linq ;0)>

[Traceyann1964]

Thanks. I have attached it. Please bear in mind I am a complete novice and may well have errors elsewhere but its a practice database for my Son -in-Law's company. The form I am having problems with is FrmRaiseInvoice. I would like the user to be able to select the customer from a dropdown box as in FrmExistingInvoice so opening up as a blank form. The subform which I have only just added to the FrmRaiseInvoice isnt working either as its asking me for the Customer ID. Thanks in advance