Selection box in Subform and assigment in Subform

[rickyfong]

I create a form and subform relationship. However, problems arose in subform.
Below is the field names of the subform table:-

1. nature (either "Out" or "In")
2. Title (selection query based on result of nature)
3. Plate (either "bright" or "dull")

In 2.TITTLE, I had the following statement in query conditon in order to do a filter according to input result in Nature,

= me![transaction subform]![nature]

My problems are as follows:

1) the title didn't work, when I run the window, it firstly appeared a message box and asking me to fill in the = me![transaction subform]![nature]. This is not what I expected. Then, when I entered value to the field nature, the title still can be selected all the items instead of based only on result of nature.

2) When I selected 'Out" in nature, I put a statement in "after update" VBA code ---> "if nature ="Out" then me.Plate = "dull"" to act as a default which in order to ease the data entry of user. However, the Plate didn't work as I expected, it simply appeared nothing after any input to nature.

Any ideas?? Thanks a lot!!

 

[rickyfong]

Sinking!! Anyone?? Please!! Thanks a lot!!

 

[rickyfong]

Hi! Is there nobody understand my problems or simply my English?? Thanks!!:banghead:

 

[rickyfong]

Are Access cannot work in these ways?? I just want the second field filtered results based on first field and the thrid field equal to one of its list value based on first field result. Second field is a selection box fields and third field is a list box field . Please help!! Thanks!!