第1个回答 2013-11-28
Form1:Private Sub Command1_Click() Form2.Show 1End Sub Private Sub Command3_Click() EndEnd Sub Private Sub Form_Load() Data1.DatabaseName = App.Path + "\db1.mdb"End Sub Form2:Private mode As Integer Private Sub Command1_Click() If mode = 1 Then Form1.Data1.RecordSource = "select * from 表1 where 地区='" & Trim(Text1.Text)& "'" ElseIf mode = 2 Then Form1.Data1.RecordSource = "select * from 表1 where 邮编='" & Trim(Text1.Text)& "'" End If Form1.Data1.Refresh If Form1.Data1.Recordset.RecordCount = 0 Then MsgBox "没有查询到数据" Exit Sub End If Form1.Text2.Text = Form1.Data1.Recordset.Fields(0) Form1.Text3.Text = Form1.Data1.Recordset.Fields(1) Form1.Text4.Text = Form1.Data1.Recordset.Fields(2) Unload MeEnd Sub Private Sub Command2_Click() Unload MeEnd Sub Private Sub Form_Load() Call Option1_ClickEnd Sub Private Sub Option1_Click() mode = 1End Sub Private Sub Option2_Click() mode = 2End Sub