Search results

yes-- it did work!! thanks! that leads me to a tougher question. I have a category and subcategory combobox. I'd like the default for the category to be the first item in its list-- which i can now do. Now how do i get the subcategory to default to the first item in its list dependent on...

I have a combobox list that runs off a query. The results of the query are constantly changing, but each time the combobox gets requeried, i'd like it to default to the first item in it's list. How do i get it to do that?

Under Default value in the Design mode for the field you want, or under the Default value in the properties of the control item in Form Design just put the date you want as the default #1/1/00# or if you want the current date =Date()

I have a table "Transactions" that has a 1 to many relationship with "AssetAcquisitions". The table "Assets" also has a 1 to many relationship with "AssetAcquisition". This enables me to purhcase more than one Asset with each transaction, but also allows me to pay for the same Asset in...

definately useful... thanks!

I have an Assets Table and I have a Business Assets Table. They are linked by an Asset ID, and the Business Assets table has a 0,1 to 1 relationship with the Assets table. I have created a form in which a person enters info for the Asset, and then if he decides it's a business asset, he enters...

thank you so much for the help-- works very nicely-- one last question-- is there an easy way to update the total as you're typing in the amount, not just after you tab out of the field, but as you're actually entering the number realtime?

Hello!! I have one main form called Receipts, and I have two subforms called Assets and Expenses. There is a many-to-one relationship for each of the subforms to the main form keyed off the Receipt ID. I want to include a Total field in the main form that totals the current Assets and...