help please

[cliff]

Hi,
Basically I want to select data from one form.. that means my project will
have 3 forms opened and updated together.
In other words form1 will have possible data (all minus data selected in
form3 ), form2 will be current data and form3 should display all selected
data all at one time. Is it possible? please guide me

thanks

cliff

 

[Jeff Boyce]

Cliff

It all starts with the data ... and you've described forms.

More info, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[cliff]

Hi Jeff Boyce

thanks of help. My data is something like
table mydata
cdate nos
1/1/2008 16
1/1/2008 23
1/2/2008 34
1/5/2008 39
1/6/2008 37
1/7/2008 41
1/8/2008 42

suppose I select 16 it should be placed table1 and 16 will be removed from
mydata.
table and I want nos remaining in mydata and selected nos i.e., table1 shoud
be updated instantly and I should able to see contents of mydata and table on
the same screen. How do I that? . Please guide me.

thanks lot

cliff

 

[Jeff Boyce]

I'm afraid I'm not any clearer about what you have or what you are trying to
do.

You mention [mydata] and [table1], but I don't understand their relationship
(or purpose).

If you are saying that you want to move the first record ("nos = 16") from
[mydata] and put it in [table1], ?WHY?!

If you were using a spreadsheet, that's probably how you'd handle it.

But in Access, you could simply add a field/column to record the fact that
the row was no longer ... (and I'm not clear here what moving it to [table1]
is supposed to illustrate/explain).

More info, please!

Regards

Jeff Boyce
Microsoft Office/Access MVP