Forum home » Delegate support and help forum » Microsoft Access Training and help » Forms design
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Forms design
Resolved · Low Priority · Version 2003
Reply Tue 29 Jul 2008, 16:21Delegate Neil said...
Neil has attended:
Access Introduction course
Access Intermediate course
Access Advanced course
Forms design
I would like to access the record I'm lookin for by typing in the number onto the form directly we could not seem to do this
For upcoming training course dates see: Pricing & availability
RE: forms design
Hello NAME,
Hope you enjoyed your Microsoft Access courses with BEST Training.
Thank you for your question regarding searching for a record in a form.
To do this you would need to use the SEARCH option (CTRL+F), or the binoculars. If you were to type a number into a form directly, you would need to program the field to automatically search for that value, in the recordset in the form.
For this to take place, you would need to create a stand alone field (textbox), and then drive a SQL query behind that box via a button to search for and find the record. There several ways of doing this, depending on your knowledge and skill with Access, SQL or VBA.
Generally speaking, I would go for the FIND option, as it gives the functionality immediately, without major programming requirements.
I hope this resolves your question. If it has, please mark this question as resolved.
If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?
Have a great day.
Regards,
Richard
Microsoft Office Specialist Trainer
|