Create a Search that will return results in a form

[scottm0690]

I am working on creating a Access Database that when a user wants to search for a record based on Name, it will return all results and then allow the user to click on that table item that they are looking for and it opens the form with all the info from the table. Thank you!!

[ranman256]

make a form that shows all records,
put an unbound text box in the header to enter the name,
when user presses enter, the list filters for that name :

Afterupdate event

sub txtBox_Afterupdate()
If IsNull(txtBox) Then
  Me.FilterOn = False
Else
  Me.Filter = "[LastName]='" & txtBox & "'"
  Me.FilterOn = True
End If
END SUB

[scottm0690]

Sorry to ask this next question, when creating a form and doing the search, do I need to create some relationship that will allow that search to fill the form fields with the table contents of the search? if that makes sense? Basically I have a form that will be filled out with check boxes and other info, then I want to use your search to find a record that will populate the form with that record search info. Thanks, sorry for the question as I am new to this and appreciate your help. If you know a good place to go that I can learn how to do this, that would be great also. thanks,

[orange]

ranman has provided the essence of the required logic. If that hasn't answered your post, then perhaps you could provide more details or a mock up of what you are trying to do. It is difficult for readers to offer more focused advice when there is only a general statement/concept in the question/post.
This forum is a good place to start --just tell us more about you, your environment and a description (the big picture) in simple English.
Good luck.

[scottm0690]

Basically what I am trying to do is create a form that has checklist items that are related to a project. When a user creates a new project they will check off what items they will deliver, once they add their project name, number, and all items they want to check off, it will save fine to the table. I want to be able to do a search for a project number or name, that will pull up that project record and all the items they have checked off to deliver in either the current form used for creating or a new form. I hope this helps. I apologize for not giving more info and if this seems basic, I do appreciate any help you can give. thanks,

[Micron]

If you know a good place to go that I can learn how to do this

Poke around at Allen Browne's site. Here's 2 things that might help, but it sounds like you're not up to speed on the very basic basics of form design. You might be diving without taking swimming lessons first, if you get my drift.

http://allenbrowne.com/ser-62.html
http://allenbrowne.com/AppFindAsUType.html

[orange]

You may also find this info from NiftyAccess helpful.

[scottm0690]

I will definitely look. Yes, I understand, run before walking not always a good thing. Thanks,