If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Need help with code
I have two tables (Credit Card Log and Vendor Information) in my database.
Credit Card Log is the main form and Vendor Information is the embedded subform in my main form. I would like to find a vendor name, which is located in my vendor information table (subform), by using a command button on my main form (Credit Card Log). Vendor Information.Vendor Name is specific to each Credit Card Log record and will not search beyond that. I would like to be able to search a vendor name to pull up the corresponding Credit Card log record main form. I have the 2 tables linked by Purchase Number, which is unique for each credit card log entry...tying the vendor information table to the credit card table. I have looked at Allen Brownes website and was unable to get the code to work successfully. I am not very knowledgable in VBA...so please use lamens terms. |
#2
|
|||
|
|||
Need help with code
Hi
you are asking the database to search for credit card logs for any vendor you choose. I suggest this is tricky to do with your current form and subform. I would use the form wizard to build a new form. You could base the new form on the vendor's table. In the wizard, choose the option which allows you to search for a specific record on the form (that is not the exact wording, but it gives the idea). The wizard will build the form and the code which will allow you to have a combo box listing all the vendors by name. When you choose the vendor, the form will show the credit card logs for that vendor. Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia "Help me." wrote in message ... I have two tables (Credit Card Log and Vendor Information) in my database. Credit Card Log is the main form and Vendor Information is the embedded subform in my main form. I would like to find a vendor name, which is located in my vendor information table (subform), by using a command button on my main form (Credit Card Log). Vendor Information.Vendor Name is specific to each Credit Card Log record and will not search beyond that. I would like to be able to search a vendor name to pull up the corresponding Credit Card log record main form. I have the 2 tables linked by Purchase Number, which is unique for each credit card log entry...tying the vendor information table to the credit card table. I have looked at Allen Brownes website and was unable to get the code to work successfully. I am not very knowledgable in VBA...so please use lamens terms. |
Thread Tools | |
Display Modes | |
|
|