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
|
|||
|
|||
Help! Open and populate form based on selected data
Hello,
I need some help. I have thought about this so much that I have confused myself. I am creating a DB that is supposed to track errors commited on insurance applications. Each application has about 17 unique line items and the DB needs to track which of those 17 items had errors, so one application may have more than one error. There are 8 different applications and I have one table that holds descriptions and ID's for all line items and all applications (total of about 140 records). My main form has general information and it is here where the user defines what application is being checked. I would like to be able to open another form with the line items related only to the application type defined in the main form and then select which of those line items had errors. I hope this makes sense and that someone can direct me to the next step. |
#2
|
|||
|
|||
Help! Open and populate form based on selected data
A combo box will allow you to select which particular file you want your form
to display. Use the combo box wizard to set up the field you want to use to filter on. After using the wizard and selecting a field, go to properties of the combo, look in events, and pick the afterupdate event. Go to code builder and type: Me.filter = "[thefilednametosearchon] = """ & Me.combo# & """" Me.filteron = true This should allow you to scroll through the combo to the file you want to display. "Pattyt" wrote: Hello, I need some help. I have thought about this so much that I have confused myself. I am creating a DB that is supposed to track errors commited on insurance applications. Each application has about 17 unique line items and the DB needs to track which of those 17 items had errors, so one application may have more than one error. There are 8 different applications and I have one table that holds descriptions and ID's for all line items and all applications (total of about 140 records). My main form has general information and it is here where the user defines what application is being checked. I would like to be able to open another form with the line items related only to the application type defined in the main form and then select which of those line items had errors. I hope this makes sense and that someone can direct me to the next step. |
Thread Tools | |
Display Modes | |
|
|