Drop down form

[lokfu]

Hi, I am a new access 2010 user. I would like create a form which has two tables
Bank_name table & Products, their has relation as attachment. for example, I select CUSTID "South" from drop list. How can I make products drop list show South_1 & South_2 only in dropdown list? If I select CustID to other, the products drop down list will show other for selection. Hope some one can help me to solve it.

Thanks a lot.

 

[pbaldy]

Sounds like this:

http://www.baldyweb.com/CascadingCombo.htm

 

[lokfu]

Thanks a lot!

But if the state is blank, Can I show all cities in drop drown list?

Thank you for your help!

Best Regards,
LokFu

 

[pbaldy]

Sure; it can start with a row source that gets them all, or use this with the requery method.

http://access.mvps.org/access/queries/qry0001.htm

 

[lokfu]

Thanks!

Sorry for bother you again. I would like make a field in the form for print no of pages and printing button. How can I make press button and printing out as same as many I want as pages field?

Thanks a lot.

 

[pbaldy]

One way would be this type of thing:

Dim x As Integer
For x = 1 To Me.TextboxName
  DoCmd.OpenReport...
Next x

 

[lokfu]

Re: delete msg

I would like delete the record automatic and no message as attachment when I press button in form button. How can I do it?

Thanks a lot!

 

[pbaldy]

http://www.baldyweb.com/SQLWarnings.htm

 

[lokfu]

I create a button in the form for print my report, but when I press the print button, it printing out the form not the report. Could you help me for print current record to report not the form?

Thank you so much.

 

[pbaldy]

Try

DoCmd.OpenReport

with the appropriate arguments.

 

[lokfu]

I have try "DoCmd.OpenReport" , but it is still print the form. Could you give me the details about the event process?

 

[pbaldy]

What is the code behind the button?