Combo requery not showing new record

C

CJ

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
 
O

OfficeDev18 via AccessMonster.com

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
 
C

CJ

Solved it!

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

Cheers
 
Top