[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 282
  • Last Modified:

Unique Values on the form and Check box properties

Hi

i am creating a form based on a table. i have two combo box based on which the information in the details section should be modified. Also the combo box should show only unique values.

How can i also stop the check box from creating new line items in the table when i click on the last check box.

And the last thing is, how can i create a column view on the forms detail section showing the first three items in the first line and the next three below them and so on.

I am attaching a copy of the database.

Your help on this is appreciated.

Thanks,
Sai.
Test.accdb
0
Saichand
Asked:
Saichand
  • 3
  • 2
1 Solution
 
DockieBoyCommented:
Sorry, I only use access 2003, so I can't open your accdb.  If you can change it to mdb I would be happy to take a look, or I am sure that someone else who isn't anti > 2003 will see this post and help you out.  :)
0
 
SaichandAuthor Commented:
attached is the file in 2003 format
Test.mdb
0
 
DockieBoyCommented:
Ok, so I am confused as to what you are trying to achieve here, could you please try to explaine again exactly how the form is to be used and the result you are trying to achieve.  :)

For your query about the checkbox creating a new line entry, it is not actually creating a record.  The new check box needs to appear so as you have the ability to create the new record.  As soon as you check the last check box it updates in your table to reflect the value of the checkbox and in doing so creates a new record, then a new little check box appears so you can continue the process.

If you would like to stop that from happening you can set the forms Allow Additions property to No.
0
 
DockieBoyCommented:
Also, in the db you don't have a primary key and all the fields data propy type's are set to Text, is there a reason for this?
0
 
SaichandAuthor Commented:
there is no reason why i have the table without a prumary key and without datatypes.

i wanted the two combo box above to display only the unique content off the table and when i coose a criteria and the detail section get modified.

Also i want the detail section to the displayed in below design.
item 1                        item 2                        item 3
item 4                        item 5                        item 6
and so on
0

Featured Post

Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now