Help! Open and populate form based on selected data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Pattyt - 06 May 2008 06:03 GMT

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.

Reply to this Message

Golfinray - 06 May 2008 13:38 GMT

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.

> Hello,
> I need some help. I have thought about this so much that I have confused
[quoted text clipped - 11 lines]
>
> I hope this makes sense and that someone can direct me to the next step.

Reply to this Message