Good Question Here!!!

  • Thread starter Thread starter CEVisker
  • Start date Start date
C

CEVisker

I will see if I can explain what I am trying to do well enough. I have
tables linked by the clients SSAN. I have created a form to enter th
date and details of we'll say "visits". With this form, I can clic
through and find the appropriate client record from the clients table
I have then added a sub-form to this "visits" form where I can add
new visit for the selected client into the "visits" table.

Now for the questions:

1. Instead of clicking through each record to find the client, I woul
like to use a combo box to find the client faster.

2. I have been playing around with the form and sub-form properties
little so that when a user needs to enter a new visit, they are no
able to edit or delete visits that are already saved. I have set bot
Allow Edits and Allow Deletions to No. I have set the Main for
properties to not allow additions so the user is not able to add a ne
client record through this form. I then set the sub-form properties t
allow additions so the end-user can add additional vists in th
sub-form that is seen when viewing the main form. The first one worked
I cannot add a new client through this form. But, I also cannot add
new visit in the sub-form that is seen when viewing the main form.

Sorry if this is long, but I have been trying to set up this data entr
form to enter in new "visits" for the clients.

Thank You,

Chad
(New User
 
1. When you add a combo box to the main form, part of the wizard you can
choose is something like "Find a record based on the selection in the combo
box".

2. Simply create a separate form to do new entries with. Add a button
(with a hot-key shortcut) on the main form that opens this "New Visit" form
and set the value for the related field to the existing record on the main
form, i.e. client i.d., patient i.d., whatever it is.

Here's another tip--I'm currently working on a db with similar concepts:
Display your subform in datasheet view. This will allow you to scroll
through the sub-records for at-glance information. Then, set one of the
fields with the double-click property to open a form to display all the
information for that particular visit in read-only mode.
 
Thanks Troy.

I tried this and the button wants to add a new record in the main form
instead of the sub-form. What did I do wrong?
 
Sounds like you created a button for "New Record" on the main form. What
you should do is create a separate form just for adding new records on the
subform. Then use the button to open the separate form to a "new record"
status.
 
Back
Top