Forms, switchboard and searches

[Kat5813]

I have a db set up that starts with a switchboard. One of the options on the
switchboard is to enter new data. This takes you to a form to add new
information to a table. The form comes up blank and will only pull up
records that you have entered during this session. The issue: would like to
have another form that would allow the users to search through and modify the
existing data in the table.

Note: when pulling up the form without the use of the switchboard, one can
see all existing records in the table.

Any suggestions?
Thanks,
Kat

 

[MikeJohnB]

When you added the form to open using the switchboard manager, you selected,
"OPEN FORM IN ADD MODE" the first form open option on the list, Select "OPEN
FORM IN EDIT MODE" the second form open option. You will then be able to edit
the existing records as well as adding new ones.

Hope this helps????

Regards

 

[Kat5813]

Thanks, that makes sense! How would I add a search to this form though in
case they have a specific patient that they want to edit?

 

[MikeJohnB]

A Previous posting from me on this subject as below.

I think the easy way to do this is to add a combo box. With the form in
design mode drag a combo box from the tools menu, use the wizard, select the
option, "Find a record on my form based on a value I selected in my Combo
Box"

Follow The prompts

Select Fields
Adjust the Widow Size
Name the Combo Label
Press finish

Now you should be presented with a drop down box containing all the records
but you can just type a value in there and providing it is in the list, the
form will return all the details relating to the item selected.


A good Demonstration from Tom Wickerath (MVP)


Combo box to find a record
http://www.access.qbuilt.com/html/find_a_record.html

(Hope Tom don't mind me posting his link)

I Really hope this helps a little