Help me pls =(

[elvin_08]

i have a table PC_UNIT then i have a field RoomLocation, PCname and Availability = "available" or "not available"

then i have a borrowing form then i have a cascading combo box for the RoomLacation and PCname

my question is what if i select 1 PC name the availability of the selected PC turns to "not available"

is it possible?

Thanks in advance

 

[r.harrison]

Hi Elvin_08

It looks like an UPDATE statement is required.

If you have your PC names in a Combo or Listbox then in the AfterUpdate event you need to put something like:

CurrentDb.Execute ("UPDATE [PC_Unit] SET [Availability] = 'Not Available' WHERE [PCname] = '" & [COLOR="Navy"]me.comboPC[/COLOR] & "';")

me.comboPC will be the name if the list/combo on your form.

Hope this helps

 

[Galaxiom]

Using a string to indicate 'Available' and 'Not Available' is incredibly inefficient.

Use a boolean fieldtype.

 

[elvin_08]

Hi Elvin_08

It looks like an UPDATE statement is required.

If you have your PC names in a Combo or Listbox then in the AfterUpdate event you need to put something like:

CurrentDb.Execute ("UPDATE [PC_Unit] SET [Availability] = 'Not Available' WHERE [PCname] = '" & [COLOR="Navy"]me.comboPC[/COLOR] & "';")

me.comboPC will be the name if the list/combo on your form.

Hope this helps

not working

 

[r.harrison]

When you say 'not working', do you mean it causes and error? or just doesn't update the record?

 

[elvin_08]

When you say 'not working', do you mean it causes and error? or just doesn't update the record?

having an error.. tnx for helping me

 

[vbaInet]

elvin, please be more descriptive when you reply. What is the error message?

You don't just say, "not working" or "having an error". Give more info so we know what the problem is quicker as we don't have much time.

 

[Galaxiom]

Your whole approach to the problem is fundamentally flawed. You are recording the availability with the PC_Unit record when you should be consulting the borrowing transactions to determine availability.

If it is allocated in a borrowing transaction then it isn't avaliable. Separately recording availability is a normalization error.