New Record...

[robtarr]

OK, I hope I can desribe this...

I have a form that displays a list box with a list of schools - each school represents a record. Clicking on the school in this list changes to the appropriate record. I'd like to create a button that will create a new record with the school name already added. Either through a combobox on the current form where the user can select the school, or through a popup window that asks for the new school name.

 

[Oldsoftboss]

Question is where do you get the new schools name from?
Do you have a seperate table with all schools or something

Anyway, my offering to your problem (Very brief and messy but)

Dave

 

[3699wat]

Dave
I really appreciate you sharing the small database. It helped me with a project. Have a beer after work.
Marcel

 

[robtarr]

OK, but I want the new school name to be added to the listbox that contains the other school names. So, I would like to update the listbox to reflect the new record.

 

[robtarr]

I thought this might be easier than trying to explain it. When the user selects a new opponent, and then clicks "New Meet", I want it to create a new record with that opponent's name in the School field of the record, which would in turn then be added to the listbox.

 

[Oldsoftboss]

Hope I'm on the right track

 

[robtarr]

I played around with it a bunch last night and got it to work - but your solution is much better than mine, and works how I wanted it to. Thank you so much for your help.