Autopopulate not working

[GreenshootProgrammer]

In my main form I have added a combobox and changed the source properties but the customer details aren't autopopulating when a customer id is selected.

http://s000.tinyupload.com/?file_id=05702272457269833949

 

[RuralGuy]

Which form and if you used the cbo wizard, did you select option #3? What version of Access are you using?

 

[GreenshootProgrammer]

I used the to wizard to create the combo box, I don't think there is a third option, Access 2013.

(I tried creating the combo box in 2007 but it didn't work)

Could it be the relationships, main query, or main form properties?

 

[missinglinq]

What is the Record Source of the Form?

 

[RuralGuy]

I used the to wizard to create the combo box, I don't think there is a third option, Access 2013.

(I tried creating the combo box in 2007 but it didn't work)

Could it be the relationships, main query, or main form properties?

No Option #3 almost always means that it is not a bound form (no RecordSource). Which Form are you talking about?

 

[GreenshootProgrammer]

What is the Record Source of the Form?

I created the form from a query made up from all the tables, but when I look at the record source for the form it lists the tables.

No Option #3 almost always means that it is not a bound form (no RecordSource). Which Form are you talking about?

The invoice form.

 

[GreenshootProgrammer]

When I try to select a different customer id from the combo box in the main form it won't let me and it makes a pinging noise. May there be a problem with the main query?

 

[RuralGuy]

You're right about no Option #3 in the wizard, which may be because your Record Source does not return any records. Do you think it should? It does not seem to have the same joins and your Relationship screen.

 

[RuralGuy]

When I try to select a different customer id from the combo box in the main form it won't let me and it makes a pinging noise. May there be a problem with the main query?

That cbo is bound and the "pinging" is because the Record Source of the Form is not updateable.

 

[GreenshootProgrammer]

Thanks for taking a look at it, do you know how I would go about trying to solve this problem? I created three invoice entries and I've tried changing the record source to the query but I still seem to get it working.

 

[GreenshootProgrammer]

relationships:

 

[RuralGuy]

Why are you using Text fields as the ID fields? They should really be AutoNumber fields and the Foreign Key fields in the other tables should be Long Integer fields.

 

[GreenshootProgrammer]

I want to be able to have custom ids.

 

[GreenshootProgrammer]

Got it working I needed to change the query. I needed to change the customer id source from the customer table to the invoice table. ^^ Thanks for your time though RuralGuy, your an asset to this community.

 

[RuralGuy]

It would seem to me that the "Invoice" form would have a query of the tblCustomer table as its Record Source. That should give you Option #3 for the cbo wizard. Just the Customer information belongs on the top of the form.

 

[missinglinq]

...No Option #3 almost always means that it is not a bound form (no RecordSource)...

Note that the key word here is almost! For an explanation of how a Form can be Bound but still not display the third option, have a look at theDBguy's article:

http://thedbguy.blog.com/2013/05/combowiz/

Linq ;0)>

 

[RuralGuy]

Thanks Linq. That is a situation of which I was not aware.

 

[missinglinq]

Actually Leo, theDBguy, only came across it recently, but has been trying to spread the word! I've been fascinated by Access/VBA for so many years, primarily because if you're serious about it, there's always something new to learn!

Linq ;0)>