In your video 5 (Appointment form), you click on 'Kirk' and then click 'Find' on the ribbon to get to the name you want. This requires someone to type the name perfectly.
I'm sure there's a lesson on a more elegant way to search for a record (e.g. Combo Box) but when I've tried to figure it out, the box works, but doesn't alphabetize.
Can you point me to the video I need for this?
Thanks! Loving these videos.
Adam Schwanz
@Reply 4 years ago
You haven't even started to climb the totem pole yet of ways to search names. I would suggest keep going with the videos in order and you'll get there.
Once you unlock VBA the skys the limit with options. The simple solution here for sorting in a combo box alphabetically would normally just be to add ORDER BY [FieldName] to the SQL statement in the row source.
Adam Schwanz
@Reply 4 years ago
I think Expert 3 begins to point at the simple stuff with SQL and order BY. So for videos you might start there, but I wouldn't skip ahead.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Beginner 2.