little problem.

Hi there, this is my problem.

I have to build a DB to manage the repair of HandHeld computer (HHC)

I have 2 tbls (tblRepair, tblNotice) link with ID. I have a Qry sorting
info that i need. such as.

company, adress, name client, ... in tbl Repair and
company, adress, name client, cost, problem... in tbl Notice


what i want to do: When i fill up the repair form with, the form
generate a ID number. (always add 1 when i enter the form)

Now when the company who repairs the HHC, they guys open the form
Notice, i have a criterias asking wich ID number he want to do a Notice
for. Lets say he type 1, hit enter, and now the info's from the tbl
Repair fills the company, adress, name client in tbl Notice.

And he just add the price and what he did on it.

But when i enter data like Date in the Notice form, it changes the ID
number back to 0 (probably cuz 0 is not use) I wonder why it changes
it? IS it because it cannot be use again? Cuz when i enter it manually
there is no problem.

re: little problem.

NomoreSpam4Me@hotmail.com wrote:
[color=blue]
> Hi there, this is my problem.
>
> I have to build a DB to manage the repair of HandHeld computer (HHC)
>
> I have 2 tbls (tblRepair, tblNotice) link with ID. I have a Qry sorting
> info that i need. such as.
>
> company, adress, name client, ... in tbl Repair and
> company, adress, name client, cost, problem... in tbl Notice
>
>
> what i want to do: When i fill up the repair form with, the form
> generate a ID number. (always add 1 when i enter the form)
>
> Now when the company who repairs the HHC, they guys open the form
> Notice, i have a criterias asking wich ID number he want to do a Notice
> for. Lets say he type 1, hit enter, and now the info's from the tbl
> Repair fills the company, adress, name client in tbl Notice.
>
> And he just add the price and what he did on it.
>
> But when i enter data like Date in the Notice form, it changes the ID
> number back to 0 (probably cuz 0 is not use) I wonder why it changes
> it? IS it because it cannot be use again? Cuz when i enter it manually
> there is no problem.
>[/color]
Is it possible that it goes to zero because it is a new record? If so,
open up the form's property sheet, click on the Other tab, and set Cycle
to CurrentRecord, not AllRecords. The default for the ID field may be
0...that's why I suspect a new record is coming into play.

re: little problem.

It was not set to the right cycle but even after doing what wou said its
not working.

You r right when you say that it creates a new record.

I'm out of ideas right now.Do u have any other ideas for me??

*** Sent via Developersdex http://www.developersdex.com ***

re: little problem.

I found that the problem is when i enter data on tne form and it Tab,
that is goes back to 0. I can cycle with Tab throught the fields without
problems, and i stay on the ID i choose but the problem is when i enter
data.

do u have any idea.

*** Sent via Developersdex http://www.developersdex.com ***

re: little problem.

found it, there was a default value set to 0 in tbl.

now it seems to works good.

thx

*** Sent via Developersdex http://www.developersdex.com ***

re: little problem.

Ugo Lavoie wrote:[color=blue]
> found it, there was a default value set to 0 in tbl.
>
> now it seems to works good.
>
> thx
>[/color]

Glad you found it. I thought it might be a default value issue. Ain't
debugging fun?
[color=blue]
> *** Sent via Developersdex http://www.developersdex.com ***[/color]

re: little problem.

hehehe, most of the time,well, only when you find it.

but i dont mind if it works the first time.

*** Sent via Developersdex http://www.developersdex.com ***