Making a Form to call up information from a table?

whoneeds8

New member
Local time
Today, 11:57
Joined
Jan 26, 2005
Messages
9
I'm making a customer survey database. Also be aware I'm not proficient with access.

All the customer information is being imported from an excel spreadsheet. That will include ServiceRecordID, ServiceDate, TechID, CustName, ServLocation, PhoneNum, and DeptID.

Another table will include records for answers to 5 questions that will be asked by a manager on the phone. That table is called TblQuestions. This table will also have ServiceRecordID to go with the answers.

What I'm trying to do is create a Form that at the top has a box for ServiceRecordID. I'd like to be able to type in the Number for that ID, and then all the information shows up on the form for that specific ID. And below all that, fields to add the answers to TblQuestions for that specific ServiceRecordID.

The reason I'm doing this is because the manager will get a report with the customer information that needs a follow up call. So I want them to be able to call up that information on the screen with the ServiceRecordID number, and also be able to add in the information that they get back from the customer with the questions that will be asked.

I don't know why I'm having so much trouble with this. But I'm not experienced with access or VBA both.
 
take a look at subforms. You can make the main form bound to the table ( through its control source) to the table that has the information for the combo. Then the subform will link based on that combo and the subforms field which matches it.

You will have to do some digging in help to accomplish this. There are also many articles online i.e. msdn knowledge base and faq's on this site.

good luck! ;)
 
Thank You, got it to work that time.
 

Users who are viewing this thread

Back
Top Bottom