Search results

solved Guys, i solved this problem, creating a flag in the before update. when the form is loaded i assigned 1 to the flag. In the before update i added a conditional... If i = 0 Then (it is the first subtask to be added, only enters here once) Me.subtask = 1 i = 1...

The main form has a field called change_id. Also, it is a tabbed form with 5 tabs where the last one is used to show the audit trail log of the ticket. So, the Audit tab has a subform which gets the info from a query, then i removed the linking fields and filtered the query with the chang_id...

The problem was the linking fields. fixed it. thx

i think that the problem is the link between the form and the subform. if i delete the linking fields, the subform shows me the audit trail of all the tasks and it does not blink. suggestions?

code This form allowes the user to modify records and each time that a record is changed the audit trail table is updated (when the save button is pressed. it helps?

coding The main form is tabbed. I wanted to add the audit trail in the last tab. The main form has code on load, on close, when the user press the save button and when a field is modifyed. Do u want to see the code? thx

Hi all, this is very uncommon... I have a form. Inside this form i added a subform whic works perfectly. However, if i add a third subform, both subforms start to blink and i cant use them. In the form i have information about a task (primary key: change_id from newchange table). In the first...

addition form Wayne, i solved the problem changing the subtask type from string to number. But now something else is wrong. If i edit an existing ticket i can add subtasks perfectly, but if i want to add a new task, this new task does not exist yet, so when it try to add the first subtask in...

references wayne, i have been there before but i dont know what to do whith that list...any help? thx in advance, Max.

subtask before insert wayne, thx for your suggestion..now i am checking almost everything excepting for your last suggestion. i added the code for the before insert and also made the field a text box instead a combo box. but now the subtask field appears empty and the following error is...

status changed but still broken Guys, i change the code 'cos the table where the subtasks are has 2 fields. Now in the before update can detect if a subtask code already exist. However, if by mistake a user try to change it and then leave the original letter, the before update strts a loop and...

i forgot to tell you that subtask field is a combo which get information from a value list. thx

i have a DB to manage tasks. The main table, which contains information about the task on itself, is populated by a form. This form has a subform to add subtasks which are stored in another table. The problem is that i can check if the information entered in the form is correct, but i can not...

transfer value from form to form problem. please i have a table with a lot of records. I created a query to get all those records which are opened. Then I created a subform from that query and i put the subform in a form. In the last form i can see the result of the query and when i double...

thx Wayne, thank you very much. Max.

Hi, all. I am sorry if i do something wrong but it is my first time here. Situation: I have an application with a login form. Once you press the login button the login form is hidden (visible=False) to be able to pass the userid to another form. In order to close the application the user needs...