Search results

thanks boblarson but no go. the ID number doesn't carry over to the form im opening.

great advice, but how do you make the value of a key carry over? to clarify: I have a 'Consultant' form with a ID number as the primary key (and is autonumbered). I would like a button to not only open a form (in my case, a 'Contract' form), but also automatically carry over the ID number from...

I'd prefer to have a separate form so that a user can search for a listing by last or first name, and to see if all records available that match whatever criteria they use (ie more than one user with the same last name, like all 5 Smith's in the database or whatever). I think it is also less...

I also managed to get this working in my database. however, it only works on an individual form. when i try to incorporate the form with this function as a subform of another form, it no longer works. what adjustments do i need to make?

any suggestions?

I have found an example of a search form that I really would like to replicate, but I'm have no idea how to implement it into my database. i have attached a stripped version of my database (only consists of a table) and the database with the search form i would like to implement. Basically, I...

thanks for the help gemma....but you have any idea how that database i attached works?

anyone have any ideas?

someone help please!

thanks mhartman for the great links. I successfully set my database to disallow duplication of first and last names. however, upon doing so I discovered I need a couple more things (which of course I have no idea how to do): 1) generating a customized message upon entering a duplicate name...

I would like to know as well...

I would love to hear about how to do this as well

need help setting combo box-based 'search form' - example attached Hi all: I currently have a database with a list of clients, and it is to be accessible to others to enter information on clients and to add new ones. However, I want to make it so that the user who wants to add a client can...

any suggestions?

It would be really great to hear how to do all this. Could this possibly run a search and display the search results, then allow a user select a record and immediately go to it? Thanks again to all that have replied, I still need to take a look at all the links but I really appreciate the help

I've tried this, but like I said the autonumbered primary key values are not carried over

My database currently has a form with 2 subforms. The main form is the ConsultantList with a ConsultantID. This ConsultantID is carried over to a Contract subform when data is entered into the subform. This Contract subform also has a ContractID number that then carries over to a Services...

how do i do that? Sorry if this is a dumb question, but I'm completely new to access

What is the best way to implement a search function into a switchboard? I need this search function to allow a user to check a database for specific names, so that they do not enter duplicates. Thanks in advance for all advice

any suggestions?