Form Issue

[ICTkirsten]

Hello

Ive made a create appointments form and the issue is when i type in the contact number of a customer it should automatically fill in the forename,surname and their ID number based on this info...

However this is not the case.
Instead When i enter the dentist forename and surname it generates a random customer ID number...

Pleasecan someone help me

THANK YOU

 

[mdnuts]

Hi ICTKirsten,

I'm unsure what you are testing.

Is the intended method
-> Type Contact number, -> Dentist Forename, Surname and ID number fills
or is it
-> Dentist Forename, Surname entered -> User ID fills?

Either way, what are you using as your control source for the data on which fields you want auto populated?

 

[ICTkirsten]

Hello,

Basically

I need this to happen : Enter customer number = customer ID, forename and surname

BUT, what is happening is.... Enter dentist ID= customer ID ( which does not apply to anything ie i dont even have a customer with that iD)

sorry i wasntclear

 

[mdnuts]

isn't that fun. Sounds like you are referencing a different field. Any chance to upload the db?

 

[ICTkirsten]

what do you mean haha.. and thank you for helping. i wish i could but its my for my school project and ive been told strictly not to post it online

 

[mdnuts]

they probably mean not to seek help online too i imagine.

What I'd suggest to do, is look at your control source of the fields meant to pull data based on another field.

Essentially what you have now, examine it in depth and check your field names, table names etc. You're close you just appear to be looking in the wrong area for the data. OR it is looking correctly you are just seeing it where you don't expect to be.

 

[essexboy71]

How about... use an unbound form and pull in the data dependant on the details you enter?
either that or create a search button which jumps to the record that matches the details you enter.