Open another Form if condition is true

[sjacksontx]

I have a form with a list box called description. If description = "fees" I want to open another form to capture additional information. If description is not "fees" then don't open. I don't know whether can use a macro openform based on condition but don't know what to put in the condition. I'm a novice VB user.


Thanks for the help.

[ranman256]

If use selects FEEs in the list, the AFTERUPDATE event of the list can fire a macro to open another form.

[sjacksontx]

i got it to work BUT when I go from one form where I picked a student id then opened new form when "fees" chosen, it doesn't keep the student id value and creates another record instead of filling in on that student. Hope this makes sense. HOw do I a) keep the student id value and b) keep from adding two new records instead of just one?

[Missinglinq]

Not quite clear as to what you're attempting, here. Do you want to

Go to a second Form and go to an Existing Record there, that matches the StudentID

or

Go to a second Form, create a New Record, filling in the StudentID in that New Record?

Linq ;0)>