469,917 Members | 1,517 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,917 developers. It's quick & easy.

Subforms and Search Function

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 ***
Dec 11 '05 #1
0 1268

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Andy Jacobs | last post: by
reply views Thread by thehuby | last post: by
2 posts views Thread by gyromagnetic | last post: by
1 post views Thread by ashraf02 | last post: by
1 post views Thread by Waqarahmed | last post: by
reply views Thread by Salome Sato | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.