Search results

Why default value is no use I'm envisaging a situation where a user is entering a sequence of records - all of which have a particular field the same - the value of this field will change with the next sequence of records, but there is no way of predicting what that value will be. I was just...

thanks thanks - how do I identify the contents of the text box in code? Private Sub Form_BeforeUpdate(Cancel As Integer) prefix.tag = prefix.text (I know this is incorrect but it hopefully explains what I want to do) End Sub Private Sub Form_current() prefix.text = prefix.tag End...

new record to use previous record data Hi, I'm trying to set up a form for user data entry, where a field on the form automatically contains the same data as the previous entry. This would save time where there are a number of records to be entered where this particular field remains the same...

thanks Thanks again Bob - instant service!

Is it possible to make a text box displaying a text field on a form only visible when a yes/no field is checked? I have tried setting it a not visible and using textbox.visible=true when the yes/no field is updated, but this makes it visible for every record, not just the one where yes/no is...

thanks again many thanks Ian

still stuck I'm afraid I'm still stuck - I've made some progress I think, but still can't get the combo boxes to cascade. I've taken the liberty of attaching my database to this post in case it is a simple mistake I've made I also have another problem as I want my form to show existing records...

cascading combo boxes Many thanks - it's knowing what to look for that count's isn't it! regards, Ian

I'm trying to set up a database of books in a small library - each book has a prefix (Maths, English, Art etc) which I want users to be able to pick from a drop down list - I can do this, but the next field is a sub-category - is there a way of populating the dropdown list for the sub-category...