473,320 Members | 1,699 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

FIXED LIST OF VALUES selected by tickbox

I have a table containing ID, Seat Number, and a YES/NO "occupied" field.

I've got two separate controls on a form
One control is a combo box showing the occupied seat number
this has a bound column of ID

One control is a tick box indicating whether or not the seat is occupied.

I would like to select the seat number and tick the occupied box (true)

I cant seem to keep a fixed list of seats with a current occupied value. Any help gratefully appreciated
Jun 17 '15 #1
4 1087
Is there a refresh problem? Or is it that you cant check the box whatever?
Jun 17 '15 #2
zmbd
5,501 Expert Mod 4TB
Query?

Open the GUI query editor
Add your table to the field
Drag your fields down to the table
in the criteria row under the yes/no field enter one of the following "-1", "True", or "Yes" (all without quotes of course)
save and execute.
This will return every record that has a true/yes value for your field.

So that we can better help you: What level of background do you have with Access and RDMS?
Jun 17 '15 #3
Good morning everyone and thanks for looking and responding to my question yesterday. I eventually discovered what was happening.

On the form which contained the two fields Seat No and true/false tick box I also had a field 'location'.

I had put an 'if' statement in an event which made the field Seat No and the true/false tick box 'not visible' when the location status was set to value 1.

This caused the record to save incorrectly.

I will make any future questions more specific but thanks for your interest, its good to know you are all out there.
Jun 18 '15 #4
zmbd
5,501 Expert Mod 4TB
Thank you for following up and letting us know what happened.
Always here to help!
Jun 18 '15 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: João Proença | last post by:
Ok the problem is this, when i try to receve the values from a form with the selection list below: <select name="jogos" size="5" multiple id="jogos"> <option value="1">Battlefield 1942</option>...
0
by: Kumar | last post by:
Hi , I am using the article code shown in below url: http://www.codeproject.com/aspnet/xmlxsltransformer.asp?df=100&forumid=118504&select=1170328 This article is very cool feature. I...
0
by: Galina | last post by:
Hello I have an asp page, which is designed to allow selection from 5 interdependant select boxes. User selects and submits. A database is queried with selected values as parameters and another...
5
by: Kris Rockwell | last post by:
Hello (again), I have gotten the dropdown list functionality to work through a few tricks (probably not the most efficient, but it works) but I am not sure how to set the default selected value....
0
by: jw56578 | last post by:
I have a dropdownlist in a panel on the page. autopostback is set to true. when i choose the second option in the the list, the selected index event is triggered fine. when i go back and choose the...
0
by: kajir | last post by:
Hi, I am new at using ASP.Net 2.0. I have various drop down lists on my master page. They refer to an SQL database. I also have a menu on the master page. I can select the values in the drop...
0
by: JenniferG | last post by:
I've worked with ASP.NET but don't know much about ASP at all. I have the following code. I would like to get a person' birthday and phone number text box populated when the person's name is selected...
2
by: geetamadhavi | last post by:
Hi All, I am a java developer got a php project from the office how to create a list.values in the list should come from the database MYSQL what to do for this please help me out as early as...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.