Tiffany,
Just another 2 cents to throw in here. If the boss wants to see them flipping back and forth between 2 spreadsheets, you can do that with the 1 table and 1 form - similar to what everyone else is suggesting, with just 1 sneaky addition.
On the form you can put a tab control. Make it look just like tabs the boss is used to using. You can then either put a version of the datasheet on a subform on each tab - filtered to show sold or active. Or, with a bit of coding - you could just have a single datasheet sitting outside of the tab controls (nothing on the tab pages - just for show), and when a tab is clicked - the datasheet refreshes with a new filter to show sold or active assets according to which tab the boss clicks.
Keep the form simple for your sake with a single form - but you can usually make it work and look like the user needs - with a little creative usage of the controls.
FWIW,
Tim Ritter
Fort Wayne, IN
> Subject: Re: [MS_AccessPros] I need help understanding something....
>
> I wish it was that simple.... The reason why I need two forms is because my boss
> wants to visually see in a datasheet view the "active assets" in one form and
> the "sold" in the other. What it basically comes down to is she is to used to
> flipping back and forth between the spreadsheets she has been using for the last
> 6 years.
>
> So... based on the table "Assets" I have created a datasheet form called Assets,
> then copied that form and renamed the new form "Sold Assets". There is a
> checkbox titled "sold" in all three. I want her to be able to check the box in
> the "Assets" form and it will move the record into the "Sold" form. The original
> record will always stay in the Assets table.
>
> How would I be able to do this?
>
> Thanks,
>
> Tiffany
>
>
>
Tidak ada komentar:
Posting Komentar