Load a value into a existing record without having to

[Guest]

I use DLookup to pull a value from a table but now I want to return a value
into a record. I have a diary in access with timeslots that can be booked
out. The day is displayed in a list box split up into 15 minute slots. Upon
clicking on a timeslot I want a customers name and phone numbers to be added
to that record.

The solution that I can think of at the moment would be upon clicking to
load a new form filtered by that record and add the data that way, but I want
to avoid having to create a new form.

Any ideas? Is there an opposite to DLookup?

 

[John Vinson]

I use DLookup to pull a value from a table but now I want to return a value
into a record. I have a diary in access with timeslots that can be booked
out. The day is displayed in a list box split up into 15 minute slots. Upon
clicking on a timeslot I want a customers name and phone numbers to be added
to that record.

The solution that I can think of at the moment would be upon clicking to
load a new form filtered by that record and add the data that way, but I want
to avoid having to create a new form.

Any ideas? Is there an opposite to DLookup?

Are the customer name and information already stored in another table?
If so, your Diary table should contain only the unique CustomerID
(rather than storing the name and phone number redundantly). To do
this you don't need DLookUp at all; instead just have a Combo Box
bound to the customerID field in the diary entry.

If I'm misunderstanding, please post some description of your table
structure.

John W. Vinson[MVP]

 

[Guest]

That is a betetr way of doing it. I have created the link which works fine.
The timetable form has a listbox on containing all the appointments. How do I
load the Customers ID into which ever record I double click on for it to
create the link?

I know I can do it with a subform but I think they look messy compared to a
listbox.
--
Adam Thwaites
Access Database Designer
adam.*spamless*[email protected]
Manchester, UK