Search results

not sure if i understood your question correctly, but try searching these forums for "cascading combo boxes"

you're welcome :)

i am on Access 2003 and on this version you do not need to select the data type, you only have to select the table and once you click ok, the data type for each field will be available on the report created.

a possible solution would be to use the NZ Function i.e. NZ(MT, 0)+ NZ(TT, 0) etc

You can go to Tools -> Analyze -> Documenter, place a tick next to the table you wish and click ok

unfortunately i am still on Access 2003 but that property is usually found at table level, but once you set it there it will have effect on the combo box as well.

you can simply set the tutorialtype field required property to "Yes", and this will ensure that a value has been selected.

you can also try the F4 key.

Hi, To be honest i do not understand why do you have a table for each location and for each month. Could you explain better what are you trying to achieve as in my opinion it is time for some re-designing.

Happy Birthday :)

i agree with missinglinq, if you want this behaviour for your entire database then the Keyboard option is the ideal way.

hi, check out this link

The true part of the iif is certainly wrong ... what are you dividing the [Closing @ Cost] with? ... you need to have something before the "/" in the true part.

in the true part of your iif statement you only have "/[Days]" so what are you dividing the [Days] with ?

Hi, you can use the selstart and selLength properties.

you're welcome :)

Hi check this link

you're welcome and i am glad that you solved your problem. Just one thing which i would change is DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 because with DoCmd.RunCommand acCmdSaveRecord

you can put the code on the onCurrent event of the form as well, so that when you open the form and the first record is shown, based on the value in the combo the textbox will be visible or not.

stdocname is a variable name. Therefore you can either insert the filepath directly instead of the stdocname or else use the method explained in my previous post. Good luck