I have uploaded file incidentreport to files section. I need help with
this. When the user makes the choice in the Incident location, e.g.
Wichita, Tulsa, Transportation I want the combo box Incident number to
update from the choice that was made. I have made three tables called
Wichita, Tulsa and Transportation with the sequential number format in
there to pull from. I can't get it to pick the next number based on
the choice. Is there anyone who can help?
Also, is there anyway I can simplify this and make it update the
Incident number based on the choice that was made any other way? e.g.
based on Tulsa choice it knows to pick the next sequential number
formatted as TIR5-000x, or if picked Transportation then pick the next
number TRIR5-000x.
Thanks for any help.
Please zip all files prior to uploading to Files section.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AccessDevelopers/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
