Help! Coding assistance would be appreciated

  • Thread starter Thread starter pactite
  • Start date Start date
P

pactite

Hi Everyone,


I am new to VBA/Access scene and started to design new database to
practice what I have learned in classes and I would appreciate any help

with my current problem.


I have form A (frmA) and form B (frmB) and in both forms I have
textboxes. In frmA, I have textboxA and in frmB, I have textboxB. When

the DB opens, the users are asked to open frmA and enter information.
After the user enters an organization name in textboxA, the user is
asked if the organization is a new organization, if they click "yes," I

would like the frmB to open up and in the textboxB display the
organization's name from textboxA and enter the information into the
corresponding table without creating a duplicate record in the table.


Can anyone help? If you have any solutions in VBA, I would appreciate
any explanation as to what each code does.


Thanks in advance.
 
Look at 'openargs' in Access help. Using this facility you can pass the
contents of a textbox in FormA to FormB when you open it. In the open event
for FormB, you can set its textbox to the same value.
-Dorian
 
On the first form, you can also check (and it seems you MUST) do a
dlookup to determine if the organization is really a NEW organization.
That way you can check yourself it is really new before asking them.

Ron
 
Back
Top