Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
Password Reminder
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old April 16th, 2013, 06:48 PM
Authorized User
Points: 308, Level: 6
Points: 308, Level: 6 Points: 308, Level: 6 Points: 308, Level: 6
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
Join Date: May 2009
Posts: 50
Thanks: 0
Thanked 0 Times in 0 Posts
Default Use same form for data entry and to search for existing record

I have a data input form that is very straight-forward.

I would like the user to be able to enter a name in the same form and be able to look up to see if there is already a record for that name. Is there an easy way to do this?

Trying to think this through, it is possible there will be more than one record for that name. That is, the same person may have had more than one "transaction" in the past. Seeing all records for the name being searched for, with several fields showing in the result of the search, would surely be helpful. (By additional fields, I am thinking the date of the "transaction", a transaction number, something that would let the user pick which existing record they want to see/edit.

And, thinking out loud, so to speak, if they are unsure whether a relevant record exists, once the user sees the options of existing records to select from, I would think that they need the option to either select an existing record to see/edit, or to begin a new record. And, of course, if there are aspects that I am not thinking of, I am open to any and all relevant advice.

I have some experience in VBA but am by no means an expert in it.

Thank you
Reply With Quote

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
I want to display record number in data entry form markw707 Access 5 August 28th, 2014 12:08 PM
Use a form for both lookup and new data entry rmccafferty Access 3 September 17th, 2009 04:54 PM
Search for a record using a form a_wahab Access 6 September 1st, 2006 12:03 PM
Need to dup a whole record in a data entry form markw707 Access 4 August 29th, 2005 10:09 AM
New Record Data entry one form lgpatterson Classic ASP Basics 1 February 8th, 2005 12:58 AM

All times are GMT -4. The time now is 09:14 AM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.