Auto Fill

[Kerrydunk]

Hi there



I am a noob and have limited knowledge of access and no SQL knowledge.
I am trying to create a database for our service team.
I am logging Jobs to our customers for completion.

I am having trouble getting the customer data to automatically populate in the Jobs Form.
I want to be able to type the customer details and populate the address & telephone number etc.. Also if the customer is not in the list I would like the option to add them to the customer table.

I would appreciate any help, also simple instructions would be a bonus!

Thanks in advance
Kerry

[pbaldy]

This get you started?

http://www.baldyweb.com/Autofill.htm

Search here on "notinlist" for a way to add new customers.

[Kerrydunk]

ok, I have started from scratch.

I have 2 tables 1 for customers and 1 for Commercial Jobs.
I want to select/type in a customer in the commercial jobs form and populate the address and contact details. would the best way to do this be a dlookup? as I was not quite sure following the steps from the link?

I have the following fields in the "Customers" table: CustomerName, CustAdd1, CustSuburb, CustPhone, CustContact and I want these populated in the following fields in the "Commercial Jobs" table: JobCustomer, JobAdd1, JobSuburb, JobPhone, JobContact.

As I dont know anything about Visual Basics I would be really grateful if someone could help me with the code and tell me where and how to insert it?
Sorry if I sound dumb :-(
Thanks

[pbaldy]

Here's where to insert the code:

http://www.baldyweb.com/FirstVBA.htm

Using DLookup would be less efficient and would be more complicated.

[Kerrydunk]

Thanks, do all of the boxes need to be combo boxes?

[pbaldy]

No, just the one you choose customer with.

[Kerrydunk]

ok, I think I may need a little more help than first thought, I have tried a few times but seem to be getting the address field instead of the name. I have tried changing the bound to number but this does not help. Is there anywhere I can upload my access to for someone to see where I am going wrong?
Thanks

[Kerrydunk]

ok, I think I may need a little more help than first thought, I have tried a few times but seem to be getting the address field instead of the name. I have tried changing the bound to number but this does not help. Is there anywhere I can upload my access to for someone to see where I am going wrong?
Thanks

I can set up a screen share if someone would be kind enough to take a look?
I am supposed to have this up and running by tomorrow for work and am starting to get to the end of my teather!! :-(

[pbaldy]

You should be able to attach it here. Compact/repair and then zip.

[Kerrydunk]

You should be able to attach it here. Compact/repair and then zip.

Ok here it is, I really appreciate the help :-)

[pbaldy]

I have tried a few times but seem to be getting the address field instead of the name. I have tried changing the bound to number but this does not help. Is there anywhere I can upload my access to for someone to see where I am going wrong

I don't see that effort anywhere. Is it in another version?

[Kerrydunk]

I don't see that effort anywhere. Is it in another version?

No thats the only version I have? What is it you are unable to see?

[pbaldy]

You said you had tried but kept getting the address field instead of the name. I don't see any code in the db that is getting the address or anything else. What exactly are you looking to get fixed?

[Kerrydunk]

Ah, I am now getting the name field but cannot get the address into the relevant fields in the Jobs form?

[Kerrydunk]

if its easier for me to show you my screen is ready for sharing
https://join.me/751-489-538