How do I stop a subform from showing more than one record.

[Guest]

Hi, can someone help a newcomer please. A simple problem, I have created two
tables [Assets] & [Warranties] which are linked by autonumber ID. I have
created an entry form to show details of Assets at the top with a subform to
fill in warranty details. When I filled in the first record details the
subform then shows duplicate fields ready for another record to be filled in.
There will only be one for each asset and I want to be able to go to my
search button on the form to get the next asset record to fill in. (I have
also put in a stop button for people entering data to close form.)

 

[AlCamp]

Sapphire,
I guess I'm a bit confused...

There will only be one for each asset and....

If there is always just one Warranty record for each Asset, then you
don't need a subform to hold that information. That One to One information
can go right in the main table, and be entered on the main form. Subforms
handle a One to Many relationship.

So, your "how not to show new records" may not really be needed here.
If so, please post back, and we'll take it from there.

If you're not an experienced Access user, you might want to rethink
trying to "overpower" Access's normal subform record handling.
hth
Al Camp

Hi, can someone help a newcomer please. A simple problem, I have created two
tables [Assets] & [Warranties] which are linked by autonumber ID. I have
created an entry form to show details of Assets at the top with a subform to
fill in warranty details. When I filled in the first record details the
subform then shows duplicate fields ready for another record to be filled in.
There will only be one for each asset and I want to be able to go to my
search button on the form to get the next asset record to fill in. (I have
also put in a stop button for people entering data to close form.)

 

[Sapphiresentry]

Hi, many thanks for your reply, very much appreciated. I
see what you mean. Althugh interestingly I did somehow
manage it for security keys/assets with a subform which
seems to work. It is just that when you finish the first
entry access goes straight to the next and adds another
set of fields ready to fill in.


Regards

-----Original Message-----
Sapphire,
I guess I'm a bit confused...

There will only be one for each asset and....

If there is always just one Warranty record for each Asset, then you
don't need a subform to hold that information. That One to One information
can go right in the main table, and be entered on the main form. Subforms
handle a One to Many relationship.

So, your "how not to show new records" may not really be needed here.
If so, please post back, and we'll take it from there.

If you're not an experienced Access user, you might want to rethink
trying to "overpower" Access's normal subform record handling.
hth
Al Camp

"Sapphiresentry"

Hi, can someone help a newcomer please. A simple

problem, I have created
two

tables [Assets] & [Warranties] which are linked by autonumber ID. I have
created an entry form to show details of Assets at the

top with a subform
to

fill in warranty details. When I filled in the first record details the
subform then shows duplicate fields ready for another

record to be filled
in.

There will only be one for each asset and I want to be able to go to my
search button on the form to get the next asset record

to fill in. (I
have

also put in a stop button for people entering data to

close form.)


.

 

[AlCamp]

Well, that's a given for all databases. Even your "main" form has a empty
form waiting for a new record... at the end of the data.
If you must suppress the "new" record, you can set the subform's
AllowAdditions to No. You'll have to set it to Yes to enter a record, and
then set it to NO after data entry.
hth
Al Camp

Hi, many thanks for your reply, very much appreciated. I
see what you mean. Althugh interestingly I did somehow
manage it for security keys/assets with a subform which
seems to work. It is just that when you finish the first
entry access goes straight to the next and adds another
set of fields ready to fill in.


Regards

-----Original Message-----
Sapphire,
I guess I'm a bit confused...

There will only be one for each asset and....

If there is always just one Warranty record for each Asset, then you
don't need a subform to hold that information. That One to One information
can go right in the main table, and be entered on the main form. Subforms
handle a One to Many relationship.

So, your "how not to show new records" may not really be needed here.
If so, please post back, and we'll take it from there.

If you're not an experienced Access user, you might want to rethink
trying to "overpower" Access's normal subform record handling.
hth
Al Camp

"Sapphiresentry"

Hi, can someone help a newcomer please. A simple

problem, I have created
two

tables [Assets] & [Warranties] which are linked by autonumber ID. I have
created an entry form to show details of Assets at the

top with a subform
to

fill in warranty details. When I filled in the first record details the
subform then shows duplicate fields ready for another

record to be filled
in.

There will only be one for each asset and I want to be able to go to my
search button on the form to get the next asset record

to fill in. (I
have

also put in a stop button for people entering data to

close form.)


.