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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sapphiresentry - 25 Sep 2004 11:25 GMT

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.)

Reply to this Message

AlCamp - 25 Sep 2004 15:28 GMT

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
[quoted text clipped - 4 lines]
> 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.)

Reply to this Message

Sapphiresentry - 27 Sep 2004 09:00 GMT

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,
[quoted text clipped - 28 lines]
>
>.

Reply to this Message

AlCamp - 27 Sep 2004 21:50 GMT

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
[quoted text clipped - 54 lines]
> >
> >.

Reply to this Message