field value dependency

[Arroyo]

hello,

I have table "items " and fields "status" and "person_id" in it, among others.


Status can be "place1" , "place2" and "warehouse"
person_id is foreign key form the person related table
I would like to make, if "person_id" is blank then "status" is changed to "warehouse"

[June7]

And when would you like this to happen? Why is person_id blank? Could have DefaultValue property of status set to "warehouse". Also code behind person_id could set the "warehouse" status if value deleted.

[Arroyo]

default value would only help for new items. when item goes to warehouse i delete person_id in items table and change status to warehouse. then item is not showing in the report that connect person and item and it shows in the report that shows items on warehouse. i would like to change (delete) only 1 field, person_id and then status change automatically.

[June7]

I did suggest code behind person_id control - probably AfterUpdate event.

But I really don't understand your data structure and processes well enough to be more specific.

[Arroyo]

how can i change automatically value in 1 field if another one is changed. for example, if table have fields item, person id, and status. if person_id is blank then status should changed to warehouse.

[June7]

As I said set DefaultValue to use 'warehouse' for new record.

Then code in person_id textbox AfterUpdate event can set value in the status field. VBA example:

If IsNull(Me.person_id) Then
Me.status = "warehouse"
ElseIf Me.status = "warehouse" Then
Me.status = Null
End If

[Arroyo]

thx but i never used VBA code...

[June7]

Macro coding does have a SetValue method.

Google it, you should find info.

I never use macros.