Search results

  1. I

    new record uses previous record data

    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...
  2. I

    new record uses previous record data

    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...
  3. I

    new record uses previous record data

    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...
  4. I

    text box only visible when yes/no field checked

    thanks Thanks again Bob - instant service!
  5. I

    text box only visible when yes/no field checked

    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...
  6. I

    dropdown list to depend on other field

    thanks again many thanks Ian
  7. I

    dropdown list to depend on other field

    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...
  8. I

    dropdown list to depend on other field

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

    dropdown list to depend on other field

    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...
Back
Top Bottom