Combo requery not showing new record

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

CJ - 17 Nov 2005 20:08 GMT

Hi.

I have Access 2003

I have one form that uses a combo to find a record. When I use the combo,
the record fills in and a new blank row is shown below, ready for the next
lookup.

My problem is this, I have another form which is a copy of the first one but
with a different record source. On this second form, when I find the record
with the combo a new blank row does not show up, so I can not use it again.

I have tried switching between single form and continuous, but continuous
shows all of my products and that is not what I want.

I am not sure what the problem is here....something really mindless I'm sure.

Any ideas?

Thanks

Reply to this Message

OfficeDev18 - 17 Nov 2005 20:54 GMT

Check the "Allow Additions" property on the Property Sheet of the second form.
If it's set to 'No' then set it to 'Yes.'

HTH

>Hi.
>
[quoted text clipped - 16 lines]
>
>Thanks

Signature

Sam

Reply to this Message

CJ - 17 Nov 2005 21:46 GMT

Good thought, but that's not it. Any other ideas?

> Check the "Allow Additions" property on the Property Sheet of the second form.
> If it's set to 'No' then set it to 'Yes.'
[quoted text clipped - 21 lines]
> >
> >Thanks

Reply to this Message

CJ - 24 Nov 2005 18:11 GMT

Solved it!

My Default View needed to be Continuous Forms AND Data Entry needed to be
YES

Cheers

> Good thought, but that's not it. Any other ideas?
>
[quoted text clipped - 31 lines]
>> >
>> >Thanks

Reply to this Message