Making a wizard

  • Thread starter Thread starter Ant
  • Start date Start date
A

Ant

I have a table with several lookup fields to other tables. E.g. the
Course_Details has a Venue field combo box that looks up the ID from the
Venue table. I can not save the Course_Details record until the venue field
is populated. However sometimes I may not yet have added the venue.
Therefore my idea is to create a series of forms that work like a wizard,
the first would ask to select the venue form the dropdown but if it didn’t
exist you would click a button to open another form and create it.



The problem I have is that when I move onto the next stage of the wizard
(because I have not yet saved the record in the first stage) this form
starts a new record (next auto number). How can I open a new form with the
same auto number as the last form even though the record as not yet been
saved? If all the information was on a signal form and saved at the end
their would not be a problem but their is too much information for a signal
form hens why I want to create a wizard type effect.



I hope this makes sense to someone and any help would be appreciated.
 
Lookup fields are the Devil's spawn. Review commandment #2:

http://www.mvps.org/access/tencommandments.htm

You can and should use a query to get exactly what you are looking for. For
the most part, tables should be used only to store data, not to lookup,
enter, or display it. That's what queries, forms, and reports do.
 
Sorry, It is probably my terminology that is being misinterpreted. When I
say a look up I mean I have used the 'Data type' Lookup wizard to link the
key field (Venue ID) with the Venue ID in my tbl_Course table. this is then
a combo box so that the user can select the venue from the dropdown box in
the course table (or Query).



My problem is that in the course table (or Query) I have several links
(Venue just being one of them) All need to be populated before I can save
the record. I am trying to create a series of forms (all based on the same
record) that will guide the user through completing the entire record (like
a wizard) but I can't save the first until all have been completed. I need
my second form in the sequence to have the same unique ID field as the
first.



I hope this clarifies my dilemma. Thanks for any further help.
 
Back
Top