Results 1 to 4 of 4
  1. #1
    5 Star Lounger
    Join Date
    Jan 2004
    Location
    Norfolk, England
    Posts
    744
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Datasheet view combobox problem (2000)

    Hi,
    I have a form which is in datasheet view.
    This form is linked to a table(TblMain) and within that table is a field called Reminder. By default this is set as 10.
    On the form I have CboReminder, that looks up values from TblReminder. TblReminder has a list of numbers with appropriate text, so "7" is "1 week", "14" is "2 weeks", and so on. Therefore the user is able to set a reminder period for a task.
    CboReminder is also set to "10" as default value.
    However, I seem to be unable to get the default value to display in the datasheet form. Is there something I'm missing? The data is recorded in the linked table, but when the person views that record it appears to be blank.
    I've tried various methods of:
    If Me.CboReminder=Null Then
    Me.CboReminder=10
    but with no success...............

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: Datasheet view combobox problem (2000)

    What data type is the Reminder field?
    What values do the following properties of cboReminder have?
    - Column Count
    - Column Widths
    - Control Source
    - Row Source Type
    - Row Source
    - Bound Column

  3. #3
    5 Star Lounger
    Join Date
    Jan 2004
    Location
    Norfolk, England
    Posts
    744
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Datasheet view combobox problem (2000)

    Just managed to resolve the problem, through rushing things to quickly (again!!!!) I had inadvertantly missed out the value of 10 in TblReminders! Thanks anyhoo <img src=/S/RollEyes.gif border=0 alt=RollEyes width=19 height=19>

  4. #4
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Datasheet view combobox problem (2000)

    Do you have a record in tblReminder with a value of 10, and some corresponding text?
    Regards
    John



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •