Microsoft Office Questions? Ask a IT Expert for Support ASAP
When I open the database it opens in contact list view; I want to use the forms in Contact Details and enter a query in the Go To search box, for instance a customer address, and the form with that address will open and show all of the details on the form from the record.
The database recognises only one field in the search box at the moment, I wish to add three more fields, such as search by postcode, by address and by name.
File ID 501508
I have attached the Access form and list view of my database, as you can see all of the fields are complete including the boxes on the form, but they will not bring up the details on any particular form by inserting the file name etc in the search box, I want to set the query to search for at least three more details to bring up the form needed.
I have attached another form which shows the details of the contact; this database will only bring up these details when typed into the name box on the top left, the query is only linked to that name box.
I want the query to also link and bring up the same information if I type in the file reference, or the client address.
That means when I open up a blank form and type in a name, or a file ref, or an address, it will bring up the form with all of the details on that record
cant find anything relating to adding go boxes to the form on Microsoft help, can you point me in the right direction.
Just to con firm, before you do the programming, will the extra Go To boxes be on the form when it is open and how will you be able to put this on my database, will it be by remote access?
That's correct, can you put three additional Go to boxes? thanks.
File ID Number(###) ###-####/p>
The Fields for the Go Boxes are , Works Address-Resident name-and Our Ref. Thanks.
I have downloaded the file but it will only search by the first and second name in the Go To box, if I put in the file ref in the Go To box the error pop up comes up with you entered text that isn't in the item list
Yes that correct, but I cannot type into the Go To box*****/em>
and bring up the form with all the details for than address I have attached a screen shot of what happens when I search for items in the fields that you have inserted
That's working fine now Many thanks