472,145 Members | 2,058 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,145 software developers and data experts.

Subforms and Search Function


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 1325

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
reply views Thread by Saiars | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.