Transfer Listbox selection to table (1 Viewer)

M

mdiamond

Registered User.
Local time
Today, 19:07
Joined
Nov 28, 2012
Messages
13
Hi All,

I would like to be able to double click an item in a listbox which would update an underlying table with the ID for that item. Is there a simple way to do this?

The listbox holds contents of the complete inventory and i would like for there to be a way to just select which of these items will be hired out for a job.

Any help on this would be greatly appreciated.

Regards
Mike
 
jdraw

jdraw

Super Moderator
Staff member
Local time
Today, 11:07
Joined
Jan 23, 2006
Messages
15,378
Need more info.
How did you populate the Listbox?
Can you show us your tables and relationships as a jpg?
 
M

mdiamond

Registered User.
Local time
Today, 19:07
Joined
Nov 28, 2012
Messages
13
Hi

Thanks for the reply - the listbox gets populated from a query which will filter to show only equipment that is available according to what gear is not already on an event.

I would like to be able to specify what equipment therefore is assigned to an eventID then take the date range for the event to determine if it will be available on the dates required.

Regards
Mike
 

Attachments

  • Relationships.jpg
    Relationships.jpg
    53.2 KB · Views: 80
M

mdiamond

Registered User.
Local time
Today, 19:07
Joined
Nov 28, 2012
Messages
13
Thats an interesting link Paul - thank you.
 
You must log in or register to reply here.

Similar threads

C
Solved FAYT Listbox Tab
Replies
15
Views
671
MajP
MajP
oxicottin
Solved Multiselect listbox loop showing there isn't data
Replies
4
Views
245
pbaldy
pbaldy
oxicottin
Solved Move selected to top of listbox
Replies
11
Views
442
Pat Hartman
P
oxicottin
Solved Two listboxes remove selections if used
Replies
6
Views
289
MajP
MajP
R
Solved Retrieve columns from a table based on a list box that contains field names
Replies
10
Views
667
jdraw
jdraw

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Top Bottom