Using a form to update data
Posted on 2011-02-27
Hi, I'm fairly new to VBA and SQL and i have what i believe is a simple problem for those in the know.
I have a main form with a command button to update dates. When i press this command button, a form opens up with 4 fields that will when updated on the form, a table will
be updated. Here are my questions.
1. I want the the form with the text boxes to be only as big as the 4 text boxes, ie,
it can't be expanded resulting in scroll bars on the RHS.
2. Is it possible to update teh dates and immediately below the text boxes have the options, "yes", 'no", "cancel'?
For now, i update the dates and I have to click the close button in the RHS corner of the form.
3. How do i make my cursor move from text box one to text box 2 etc once the dates have been updated?
Any form of help will be greatly appreciated.