+ Reply to Thread
Results 1 to 2 of 2

Access - check a values in a table

  1. #1
    Forum Contributor
    Join Date
    Poznań, Poland
    MS-Off Ver

    Access - check a values in a table

    Hi everyone.

    I would like to ask you for a tip how to solve following problem:

    1) I have a table named 'Insuarance'. There are a few columns but one I am interested with is the Column: Month
    2) I have a form based on that table called 'Add a Insurance"

    What this form does is to add a new record into a table.

    However my problem is that I need to achieve following goals:

    1) The form shows me by default value with next month in the order from January to December
    2) The form checks if the record with a following month name does not already exists

    For example:

    I have in this table records from January to April so then be opening a new form it shows me by default May (in a combo box) and allows me to add a new record. But when I choose March for example in a combo box and try to add a new record then a message box appears "Month already added to a table"

    Can I achive this in Access?

    Thank you in advance for any tips.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    Steamboat Springs
    MS-Off Ver
    MS Office 2019

    Re: Access - check a values in a table

    Probably, but without seeing the whole picture it is difficult to say. It will probably require you to tweak either your Macro or VBA codes (they are different in Access). You will need to see what is happening behind the curtain.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)


Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1