Hi,
There are two sections to the form that I am creating. In the top
section, I have the fields that I want the users to be able to update.
In the bottom section (subform), I have all the records listed in the
datasheet view. These records are locked so that users can't manipulate
them at all, only view them.
1.) Since the record source in both the main form and subform are the
same, I know I can link them using any of the fields. If a user
accesses one of the records in the main form, is there a way to show
that record and all the records before and after in the subform
Datasheet view in the bottom half of my form?
2.) I want to create a search function for my users because there will
be approximately 40,000 records in this database. I have figured out
how to create a query that takes input from the user and produces the
results. How can I take that query and apply it to the record source
for my form so that when I search for *bank*, my form will populate with
all records that contain the word bank in them?
If anyone has insight on these two problems, I would greatly appreciate
it. Please let me know if anything is unclear and I can clarify.
Thanks for all the help.
*** Sent via Developersdex http://www.developersdex.com ***