Limiting records to one per subform

  • Thread starter Thread starter Sergio
  • Start date Start date
S

Sergio

Hi there,

Hope someone can help me out...

I'm creating a contact management database. I have
multiple linked tables for each client. I've created a
form called "tbleAgency" to create, edit and view the
client information. I also have 5 subforms within
the "tblAgency" form. All records link fine, problem is
with the users.

Each subform should only have ONE associated record,
however, if a user is in one of the subforms (transparent
to them, they think it is all one form) and they use the
scroll button on their mouse or the next record command in
file menu, it creates a new record. From the user's
perspective, it looks like all the fields are blanked
out.

So, to summarize, I need to give users the ability to
create a new Client, but each subform should behave as if
it did not allow for adding new records. Problem is that
if I set the add records value to "no" the subform doesn't
appear with the parent form.

Hope I'm making sense.

Thanks!
 
Hi, Thanks. I did look into this, but I can't add .dll
files since this is an office enviornment. Also, that
still leaves the keyboard shortcuts, tab key and file
menus. I know I can block those, but I'm thinking there
has to be a cleaner way of doing it.

Any ideas?

Thanks
 
Hi, Thanks. I did look into this, but I can't add .dll
files since this is an office enviornment. Also, that
still leaves the keyboard shortcuts, tab key and file
menus. I know I can block those, but I'm thinking there
has to be a cleaner way of doing it.

Any ideas?

Thanks
 
Back
Top