User Form

[Buffy]

I am designing a booking system and I need a user form where you can select the time from a drop down list and then when you save that record, the time is removed from the list so that an appointment cannot be double booked.

Any ideas please?
Cheers,

 

[Corticus]

Hi,

User the form wizard to make a basic form looking at the table with the appointments.
Delete the textbox it puts on the form for your date.
You need to then insert a drop-combo that will house your date. I'm not sure how you want the dates to show up in the drop-combo, though. You'll need to either make a table with the times you want to be able to choose from(use the wizard, tell it you want the combobox to look up values in a table, and pick this table), or enter the values as a list.
Tell the wizard you want the selection from the combobox to update a field value, the date field in your appointment table. You can also do this by right clicking on the drop combo, select properties, and set the control source to the date field in the appointment table.
Now, go to the appointment table, and set the date field as your primary key. This will prevent any duplicate dates, without trying to get all fancy with it.

HTH,
_________________<EMBED width="118" height="52" src="http://corticus.biz.ly/CorticusLink.swf"></EMBED>
This message was edited by Corticus on 2002-11-27 11:20
This message was edited by corticus on 2002-11-27 13:41

 

[Russell Hauf]

This isn't a solution to your problem, but if you decide to try the route suggested above, you can actually right-click on the text box and select "Change To", and then change it to a List Box or Combo Box. But I think that what you're trying to do is quite complicated...

-rh

 

[Corticus]

Russel,

you can actually right-click on the text box and select "Change To", and then change it to a List Box or Combo Box.

Thanks for adding that, I didn't know you could change an object this way. That should save me some time in the future.

I appreciate the extra knowledge!
Corticus