By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,594 Members | 3,291 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,594 IT Pros & Developers. It's quick & easy.

How to find a record from values in another form.

P: 5
I have a form that i use for customers to input information that i will use to locate a specific part. This part will have a specific name that will consist of a concatination of one letter from each feild that is in the form. I am not sure on how to do this, but i was thinking that i could use a subform that displayed only one record that i could set up with the first feild in the subform to be a look up feild.(There is a table already set up with a concatination of partcodes that i will be searching for.) I thought i could auto populate the feild witht the concatination from the text feild that use in the main form to pull in the record that i need in the subform.

My goal is just to use the main form to be able to locate a record and retreive a price on a part. Maybe this is simple but i am not quite sure on the procedure.

Any help would be greatly appreciated.
Aug 21 '06 #1
Share this Question
Share on Google+
2 Replies

P: 179
Hmmm... Lemme think.... Nope.. I don't getcha.

Aug 24 '06 #2

P: 5
What i am trying to accomplish for example: Suppose that your a car dealer and you have a entry screen for a customer to input all the features of a car that he or she wants. When all the questions and descriptive answers on the screen have been filled out the program now does a search and finds that right car for that person. It's also on the same principle as a personals add you fill out to find your one and only soul mate. What i am trying to do is find the one part that customer needs from a list or specifactions that they input.

Hope this makes a little more since.
Aug 24 '06 #3

Post your reply

Sign in to post your reply or Sign up for a free account.