• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Assisting Data Entry

You can do a lot to help make sure the user of your application enters correct data by defining default values, input masks, and validation rules. But what can you do if the default values come from a related table? How can you assist a user who needs to enter a value that’s not in the row source of a combo box? How do you ensure that the user enters a hyperlink in the correct format? Is there a way you can make it easier for your user to pick dates and times? And how do you show and help the user edit linked picture files? You can find the answers to these questions in the following sections.

Filling In Related Data

If you remember from Chapter 3, “Designing Your Database Application,” the tblContactProducts table in the LawTrack Contacts database has a SoldPrice field that reflects the actual sales price at the time of a sale. The tblProducts table has a UnitPrice field that contains the normal selling price of the product. When the user is working in the Contacts form (frm-Contacts) and wants to sell a new product, you don’t want the user to have to go look up the current product price before entering it into the record.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint