Inserting from index ??

[PhilipEwen]

Hi, not really sure what this procedure is called, so i shall try to explain it.

I have 2 forms. 1 is a Timetable form which has text boxes for every 15 mins over a period of hours. The other is a list of customers, which is a continuos form and based on a query.

What i want to be able to do, is that when a certain box, say 0830 is double clicked on the TimeTable form, the customers form opens, showing all customers. When you then double click on a customer name, the customers form is closed and the TT database is updated, with the customer double clicked on, in the correct timebox.

I also have the added issue that the TT form is opened based on a query. This query originates from a previous form, which allows you to select a person for whom the TT is relevant, and the correct date for the TT.
The problem being is that as this is based on a query, if no entries are made for that day for that person, then there is no entry in the TT table for that day. Therefore I am assuming that a statement would have to be incorporated, saying something along the lines of:
If TT query is null, then use append query
else use update query.

As I am not particularly good at VBa, could someone kindly give me some pointers as to how to go about this.

Many thanks

 

[doulostheou]

I don't quite understand the second half of your question, but I can take a guess at a possible solution for the first.

If I understood your question, the following should work.

On your TimeTable form insert the following code into the double click event:

DoCmd.OpenForm "Customers"

On your Customers form insert the following code into the double click event:

Forms!TimeTable!ActiveControl = CustomerName
DoCmd.Close

That should do it.