Checkbox Problem (1 Viewer)

N

newdream101

New member

Local time

Today, 23:47

Joined

Oct 24, 2017

Messages

1

• Oct 24, 2017

• #1

Hi, Since I'm new here,

I've have a question bout my form this is an Interview Date and Room bookings.

How to make the Room Booking"Bilik Temuduga 1" checkbox its in Bahasa Malaysia to be disabled, if someone is already book the room on the same booking date base from the "Tarikh Temuduga" Field

 

Attachments

• 
  Capture.PNG

  34.3 KB · Views: 102

Ranman256

Well-known member

Local time

Today, 11:47

Joined

Apr 9, 2015

Messages

4,339

• Oct 24, 2017

• #2

in the form ONCURRENT event,
check if the box should be Enabled if nobody booked this date:

chkBox.enabled =IsNull( Dlookup("[id]","tBookings", txtDate & " between [BookStartDate] and [BookEndDate] "))

 

pbaldy

Wino Moderator

Staff member

Local time

Today, 08:47

Joined

Aug 30, 2003

Messages

36,124

• Oct 24, 2017

• #3

FYI thread moved to a more appropriate forum.