same data(table) to be display 2 diffrent form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

deen - 30 Jul 2008 13:59 GMT

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

Reply to this Message

Golfinray - 30 Jul 2008 18:11 GMT

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.

> hi all,
>
[quoted text clipped - 39 lines]
> Regards,
> Deen

Reply to this Message