Search results

I have 2 tables with multiple-field primary keys; each record is uniquely identified by both a FarmerID field and a Crop field. On the form for Table2, I'd like a combo box to show what fertilizer was entered for that record in Table1. I've tried the following code...

I'm creating a form based on two tables that are linked by an ID number. I'd like to be able to type in an ID number for table A, and see data from table B displayed for the corresponding ID number. Is there an easy way to do this?

How can I set an Autonumber field to generate random, 6-digit, positive numbers? When I select the random option, the autonumbers generated are from 5 to 9 digits, and often negative.

Is there a way I can vertically rotate fields and labels on my form so that they read from bottom to top? I've only been able to make them read top to bottom.

I'm trying to create a form that combines 341 fields from 16 different tables. The tables are all linked by one-to-one relationships with an ID number field. The Forms Wizard is unable to create my form, apparently because I have too many fields. I tried creating a form using just one field...