Open Form based on User Input

  • Thread starter Thread starter Greg
  • Start date Start date
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!
 
This is a classic Form/SubForm situation. The Form should be based on
tblProviderData table and the SubForm on tblClaimData.
 
Back
Top