Creating Records with Navigation Limits in two linked forms

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

Guest

I have a master form, "Organizations," that contains a company's name,
address, phone number, etc. Related to that form, I want to click on a
"Records" button to bring up the "Records" form so that I can enter data for
a conversation I have with someone at that particular organization. The
records may be entered in possibly more than daily. So, let's say I set up a
new organization that automatically picked ID 186 for that particular
company. I want the Records form to open when clicked, automatically create
a record for ID 186, date/time stamp that record, and begin entering notes
for my call. Then, another day, I want to go back to that organization from
my master form and see that record there for my call log and be able to
create a new one with the same ID 186 (automatically), and so on. Then comes
company ID 187, associated records automatically, and etc.

The other thing is I don't want to be able to hit the "next record"
navigation button at bottom for it to create a new record. I want to only
use the "create record" button to create new records. I haven't found
anywhere how to disable the next record button from creating new records!

Help!
 
I have a master form, "Organizations," that contains a company's name,
address, phone number, etc. Related to that form, I want to click on a
"Records" button to bring up the "Records" form so that I can enter data for
a conversation I have with someone at that particular organization. The
records may be entered in possibly more than daily. So, let's say I set up a
new organization that automatically picked ID 186 for that particular
company. I want the Records form to open when clicked, automatically create
a record for ID 186, date/time stamp that record, and begin entering notes
for my call. Then, another day, I want to go back to that organization from
my master form and see that record there for my call log and be able to
create a new one with the same ID 186 (automatically), and so on. Then comes
company ID 187, associated records automatically, and etc.

The other thing is I don't want to be able to hit the "next record"
navigation button at bottom for it to create a new record. I want to only
use the "create record" button to create new records. I haven't found
anywhere how to disable the next record button from creating new records!

Help!
Click to expand...

You haven't mentioned what version of Access you are using, so I am
unsure of which bugs you may have. Access 97 and 2000 had some
problems with unintentional navigation causing record updates. The
only way I have found to create bulletproof programs in Access is to
use unbound forms and code everything by hand. It's more work, but
more flexible too. You would gain complete control over the data.
 
Ah... Sorry about that. I'm running Access 2003 with upgraded service packs
to current. I guess I assumed there wouldn't be any bugs if I've upgraded to
the latest service packs, upgrades, and the like. Still, I have a can of
worms I need to contain!!!

Thanks for your help!
 
Back
Top