Look up different Query

[naungsai]

Dear friends

I have a form with a subform. In the subform it includes a combo field looking up for a datas.

If the form goes to "New Record", I want the combo field look up query(A).

If the form is navigating "Previous record", the combo field will look up another query(B).

Can someone help to do this? Sample file is also fine.

Thanks in advance

Naungsai