Access Multi purpose form

I would like to create a form that does two things:
It will provide an alphabetized listing of the contents of one table (field one, field two, field three - sort by field 1)

If the information is not contained in the above, the second half will give the person the ability to add the information into these three fields.

I can easily get the second done, my problem seems to be getting the first half on the same form.

Is this possible?   Access 2013
Who is Participating?
Helen FeddemaConnect With a Mentor Commented:
I agree about the usefulness of the Access 2007 split form.  For versions before 2007, see my Access Archon article on creating a fake split form:
Rey Obrero (Capricorn1)Commented:
use a query as the record source of the form instead of the table

sample query

select field1, field2, field3 from TableX
Order by Field1
PatHartmanConnect With a Mentor Commented:
If you are using Access 2007 or newer, you can create a split form.  One part of the form shows the records as a list, the other part shows single record view for the record that is selected in the list - or a new record.

I don't like the way the Access split form works so I tend to build my own.  You can do that with an unbound main form and two bound subforms.  One for a list view and the other for a single record view.  In the Current event of the list form, you requery the single form.  The single form has a RecordSource query that references the list form.  So  -

WHERE myfield = Forms!mainform!lstsubform.Form!myfield

And the code goes into the Current event of the list subform.

mjburgardAuthor Commented:
Both of these helped a lot.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.