1 Table, 1 Form, 2 Records (1 Viewer)

Pompilass

New member
Local time
Today, 23:31
Joined
Jan 10, 2014
Messages
2
Hi all,
Probably a simple solution to this, however I can't get it to work.
I have 1 table and one form and need two different records from that table on my form.
Please help :mad:
 

pr2-eugin

Super Moderator
Local time
Today, 23:31
Joined
Nov 30, 2011
Messages
8,494
Hello Pompilass, Welcome to AWF ! :)

Simple answer to your Question Form in Datasheet View or Continuous Form.
 

RainLover

VIP From a land downunder
Local time
Tomorrow, 08:31
Joined
Jan 5, 2009
Messages
5,041
There is a Wizard that will show you how to do this.

Find it in Forms in the Database View.
 

Pompilass

New member
Local time
Today, 23:31
Joined
Jan 10, 2014
Messages
2
Oh thanks, but I saw the wizard there.
It only gives me datasheet records to display if multiple :mad:
Right:
I have 1 very large table with 7000 records.
I need to search on one form for record A and record B and then print them out from one print form. :banghead:
Works all great for record A but don't seem to able to link record B to the same table, unless I copy the data, which is no good as those records keep changing. Don't want to do it twice.
At the moment I have two separate print forms for those records, just a bit of a bummer to feed the paper in again.
Apart from that I hate it if I can't figure out something. That's how I learned in the first place. Keep trying and thinking lol
;)
PS Win 7 Access 2007
 
Last edited:

RainLover

VIP From a land downunder
Local time
Tomorrow, 08:31
Joined
Jan 5, 2009
Messages
5,041
I need to see a copy of your Relationships.

Can I see a screen dump please.
 

WaiveIt

Registered User.
Local time
Today, 15:31
Joined
Dec 2, 2013
Messages
58
Based on the lack of details I am assuming it is something like.

Sellers and Buyers - both People. Or Destination and Origin - both Addresses.

Maybe two unbound subforms on one main form?
 

Users who are viewing this thread

Top Bottom