Hi Peter,
As part of the macro that opens the 'ServiceA' form it closes the
Customers form and saves the info prior to opening the ServiceA form
so I do not think this is the problem. I did find that if I create 1
table with fields for customer info, service a fields, service b
fields etc, then run the same macros, information is available from
one form to the next. The problem comes when someone tries to buy
more than one service a.
--- In [email protected], "phoogenb" <[EMAIL PROTECTED]> wrote:
>
> Hi Joe,
>
> The problem is that the first new record you have created is not
yet
> saved into the database when you try opening the second form.
Since
> you're using macros, try calling the save record command before
> opening the form.
>
> If you're using VBA, the better way to save the record is to let
the
> forms Dirty property = False.
>
> Good luck,
>
> Peter Hoogenboom
>
>
> --- In [email protected], "Joe" <investigator@> wrote:
> >
> > I have been working on building an Access database file for our
> > business for about a week now. I keep running into the same
problem
> > no matter how I try to start the datbase. Here is the scenario:
> >
> > We offer basically 4 services to our customers. A customer may
buy
> > one service, or all 4 or multiple repeats of the same sevice.
When
> a
> > new customer calls, I want to open a form and take some generic
> > information (i.e. name, address, phone number etc.) then at the
> > bottom of the form I would like 4 buttons (1 for each type of
> service
> > we have). I have done this, and created 4 forms that are based on
> > each service, and the buttons each work properly (using macros)
to
> > open the proper form.
> >
> > So Customer1 calls, I take their info, and they want ServiceA so
I
> > click the ServiceA button. The ServiceA form opens, and here is
my
> > problem. On the ServiceA form, I have fields for customer name,
> > address, phone number etc. (all of these fields are based on the
> > Customers table so I am not duplicating data in two tables) and I
> > would expect that these fields would be complete based on the
> > relationship between the two tables. (Customer1 is assigned an
> > autonumber when the record is saved and this autonumber is linked
> to
> > the Customer number on the ServiceA form.) Unfortunately, when I
> open
> > the form, all the information is blank. If I type in the Customer
> > number (and I make that number the same as the autonumber
assigned
> in
> > the Customer table) then close the ServiceA form, then open the
> > ServiceA form again, then like magic, the Name, address, and
phone
> > number etc. is there. Is there anyway to make this information
> > automatically fill in to the form I select when I click it's
> > respective button? I have searched through many forums, and sites
> > trying to find a solution, I even bought Access for Dummies, but
I
> > can not figure out where I am going wrong.
> >
>
