Open Form based on User Input

G

Greg

I have a database with tables: tblProviderData, tblClaimData, tblRRC.
Forms are: frmLoginClaim, frmAddClaim, frmAddProvider


Relationships are:
tblProviderData.ProviderID -> tblClaimData.ClaimProvID
tblRRC.RRCCode -> tblClaimData.ClaimRRC


frmLoginClaim is the main form, which allows the user to enter a
ProvDEC number, which there is only one per provider. What I need is
for the form to search the tblProvData for the record... if found open
frmAddClaim and populate the provider data on that form (for reference
only) so the user can enter data into tblClaimData. If not found open
frmAddProvider so user can add provider, then open frmAddClaim. Can
anyone point me in the right direction?

Help please!
 
K

Klatuu

This is a classic Form/SubForm situation. The Form should be based on
tblProviderData table and the SubForm on tblClaimData.
 
Top