Inactive Record Transaction

[Usman55]

Hello all,

Hope you all fine

I have an access database for pay pension to pensioners in my database i have some inactive accounts
my format is:
account number= 1274A
name of pensioner= umair khalid

in my transaction form combo box hide my data as 1274 but when i put 1274A transaction will done.


i want when i put an inactive account i.e(1274 or 1274A) access prevent transaction in this inactive account.


Anyone Help me on this

[NeoPa]

Hi Usman.

I would start by ensuring your ComboBox Control contains only those accounts that are not inactive. Also make sure that the ComboBox properties ensure that only items from the list can be used.

[XPS35]

First of all we should know how you can tell an account is inactieve.

In general you must have a query as rowsource for the combobox that selects only active accounts.