same data(table) to be display 2 diffrent form

[deen]

hi all,

i have doubt in acces,

i was creted the table in the name of table1.

table1 contain,

reg no. name add amt

1 aha kjk,hfg 100
2 dee uyrt,htg 200
3 anto yter,kail 300

i need to be design the form1 its contains only,

reg no.


and in form2 contains.

name add amt


Result i need,

in form1 i need to change the reg code(with use find

option)automatically form2 also based on reg code.

eg:

in form1 enter the reg code

Reg code: 1

in form2 need to show

name add amt
aha kjk,hfg 100


do the needful

Regards,
Deen

 

[Golfinray]

You need to create a form and subform. Regcode on the mainform, name, add and
amount on the subform. The subform must be linked to the mainform by
something common to both, like a id number. Then to get the search to work
correctly, you need to put an unbound combo box on the mainform. Use the
combo wizard to select the reg# filed in the table. Go to design view in of
the form and right click on the combo to go to properties. Go to events and
on the afterupdate event, start the code builder (little button out to the
right.) The type:
Me.filter ="[reg#] = """ & me.combo# & """"
Me.filteron = true
The combo# will be listed there for you, like combo29 or combo6.