Search results

There are a couple of possibilities. Idea 1: Don't do the work in the main form, do it in the Revision History Adding form. When the "OK" button is pressed, and before you close that form, do something like: Forms!frmMain!txtRevHist = Forms!frmMain!txtRevHist & Me!txtName & Me!txtDate &...

The trick is to set the LimitToList property of the combo to true - that way you can trap the fact that you're trying to enter something not in the list. The event that your code goes in is the OnNotInList event. Here's a very rough-and-ready bare-bones kind of example. I'm assuming that the...

If the MakeTable query includes an AutoNumber field in its output, then that field in the new table will also be an AutoNumber field. However, the values the MakeTable query inserts in the AutoNumber field in the new table will be based on the values in the query's source table, they won't be...

I wasn't quite sure if you meant that you actually wanted to modify the data, or just change the table so the values appeared differently. If you want to modify the data, you could use the format function: Format([NumberField],"00000000") So in an update query, that would be: UPDATE <table...

Add two extra columns to the query. In the field box of one type something like: "DateBegin: [Enter Shipping Beginning Date:]", and in the other "DateEnd: [Enter Shipping End Date:]" (don't include the quotes). This will cause the query to return two extra columns (DateBegin and DateEnd) on...

You don't say which version of Access you're using, and I've only got A97 to hand, but I don't think (despite what the help says) that HasData is a (sub)form property. It works fine with reports, but it doesn't ssem to work with forms at all. Simon

Sorry, where I said > Bind this form to qryStoreCategoryID I meant > Bind this form to qryStoreCategoryAisle Sorry, Simon.

This is a bit convoluted, but bear with me. It's the subform part that's causing you the grief and you don't really need it. Instead, start by putting the combo (or whatever other means you use to select the current store) in the header section of the main form. Then create three queries...