Input forms

  • Thread starter Thread starter Juli
  • Start date Start date
J

Juli

I am having some difficulty with my input forms. I am
sure that it is because there is some key process that I
am not understanding.

Here is what I have tried:

I started with the following tables and associated forms:

Main Inventory (Consists of all fields in the other forms)
Hardback
Paperback
Cd
Cassette
VHS
DVD
Magazine

Each table has a corresponding input form with the main
inventory form being the trigger to launch the individual
form when it's value is selected from the dropdown.

My goal: Input the data into the appropriate input form
and have the data update the associated table and update
the appropriate fields in the main inventory table.

The update of the main inventory table did not work past
the first record.

2nd Attempt:

Main inventory table (Same fields as before)

Forms as listed above triggered by the main inventory
dropdown list.

When I input the data into the table it works fine until
I switch to another input form. It then starts with
record one instead of a blank record.

Is it possible to relate the forms in such a way that
they read the main inventory table and automatically
start with a blank record? I want to use these forms
specifically for data input.

I want to setup a search with separate forms for actually
reviewing the records.

Is either one of these setups workable?

Thanks in advance
 
Dear Juli

Just from your description, it would seem that you are
complicating things for yourself somewhat. I am assuming
that you are new to using access, and as such I will try
to keep my reply short and not too full of technical stuff.

Firstly, do you really have a need for separate tables for
each of the media types? If they all contain the same type
of information, eg title, publisher, cost, bibliographic
reference, isbn number, etc then you will only need to
have the main inventory table with a field in it called
something along the lines of "Media Type". Make this field
a lookup field (the lookup wizard will help you through
the process). This way you will be able to filter and use
this field for query criteria for reports and the like.

With regard to your input form, in design view, select the
properties of the form and in the "on Open" event, click
on the 3 dots to the right of the event property, and
select to create a macro. In the macro window select goto
new record, save the macro. This way, whenever the form
opens, it will open at a new record.

I hope that this helps, but should you need further help,
pleases either post back here, or mail me directly if you
need step by step directions.

Kind regards

Paul
 
Back
Top