I have a combo box on a form that allows the user to select a record from 
a dropdown list which then uses rs.bookmark to populate the form.  It 
works fine if I open the form directly from the database window. You 
choose something from the combo box and the form gets duly populated.

I have another form which calls this form to open with a specific record 
if you hit one button, or to add a new record if you hit another.  Either 
way you open the form, the lookup combo box doesn't work at all.  I 
assume this is because it is opening in acFormEdit or acFormAdd mode and 
is filtered somehow to prevent record browsing.  Is there some way I can 
override this effect so that the lookup combo will function no matter how 
the form is opened?

Hope I'm making sense here.  Any suggestions appreciated.

I believe I have use this method many times without a
problem.
open the form in default mode and if the code behind the
controls is OK.
As a last thought, I would remove the option to open the
form at a specific record.
or remove the combo box. these two options may be the root
of your problem.
TomM

-----Original Message-----
From: Daren Porter [mailto:porterdt@h...]
Sent: Friday, August 23, 2002 8:33 PM
To: Access
Subject: [access] lookup combo box won't function in add or
edit mode


I have a combo box on a form that allows the user to select
a record from
a dropdown list which then uses rs.bookmark to populate the
form.  It
works fine if I open the form directly from the database
window. You
choose something from the combo box and the form gets duly
populated.

I have another form which calls this form to open with a
specific record
if you hit one button, or to add a new record if you hit
another.  Either
way you open the form, the lookup combo box doesn't work at
all.  I
assume this is because it is opening in acFormEdit or
acFormAdd mode and
is filtered somehow to prevent record browsing.  Is there
some way I can
override this effect so that the lookup combo will function
no matter how
the form is opened?

Hope I'm making sense here.  Any suggestions appreciated.
---
Change your mail options at http://p2p.wrox.com/manager.asp
or