Combo requery not showing new record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Solved it!

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

Cheers
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top