new blank record

R

Rod

I am new to Access. I have created a form based on a querie. I managed to
create the form okay and it has the information I want, however it is not
giving me the option to add a new blank record. For some reason, the option
at the bottom is grayed out. Can someone shed some light on why that might
be?
 
R

Rod

No, I cannot. I followed the link and read the information. It helps
somewhat, but
the question is ; Is there a better way. I have information on three
tables that I would like to bring together on one form so that I can record
events in one place,but have it stored on individual tables. Is that
possible?
 
B

BruceM

There is no way to say without knowing more about your table structure, and
about the tables that are being included in the query. What are the tables,
and how are they related?
 
R

Rod

I have a stroage shed full of equipment such as power wheelchairs, scooters,
walkers and the like. In order track the items whereabouts I have created
some tables. They are 1) Consumers(the people who we loan the items to) 2)
Equipment- this is the information such as serial numbers, item, and such
3) Events- Releases, Returns,Purchases, ect. I want to make a form that
brings the consumer name and address from the "Consumer" table the item from
the "equipment" and the event from the "Event" table. They are all related
by fields. For example the item is assigned a "tag number" on the
"equipment" table and is the same "tag number" that is on the "event table".
 
B

BruceM

As I understand it, each consumer may be associated with several pieces of
equipment, and each piece of equipment may be associated with several
consumers. Therefore there is a many-to-many relationship between equipment
and consumers.

tblConsumer
ConsumerID (primary key, or PK)
FirstName
etc.

tblEquipment
EquipmentID (PK)
EquipDescription
SerialNum
etc.

tblEvent
EventID (PK)
ConsumerID (foreign key, or FK)
EquipmentID (FK)
DateIssued
DateReturned

Create a relationship between the PK fields in tblConsumer and tblEquipment
and their namesake fields in tblEvent. Click Enforce Referential Integrity.

Create a form based on tblConsumer, and a subform based on tblEvent. The
subform on tblEvent has a combo box bound to EquipmentID, with tblEquipment
as its row source. EquipmentID will be the first column of the row source
query, and EquipDescription the second column. Set the combo box column
count to 2, its bound column to 1, and its column widths to 0";1.5" (or
whatever works for the second column). Add other columns such as SN as
needed, but the bound column will be 1 in any case.

This is a thumbnail description, but the approach should give you what you
need. Experiment on a small scale, with just a few fields from each table
and simple forms. Extra fields can be added as needed.

You could also build a form based on tblEquipment, with a subform based on
tblEvent. The combo box on the subform would be based on tblConsumer. It
depends on how you want to manage the data. In any case, with this
structure you can look at equipment per consumer or vice versa, as you
choose.
 
Top